This content has been marked as final. Show 3 replies
I hear good things about the book "Teach yourself SQL in 10 minutes" by1 person found this helpful
You are asking the a very foundational question in how RELATIONAL
databases such as Microsoft SQL work. The part you will want to jump to
is how to JOIN two or more table together on one or more common fields.
You should not have two record sets, but rather one record set with the
two parts related together.
It's not that simple. Both recordsets are built from multiple table joins, but because of the layout it wouldn't do me much good to join them into one. I actually got the first record to output correctly using dynamic code in the SQL statement, but when you click to the next record, the subdata does not update. Is there any way to trigger the subdata to update when the main dataset changes? Full code attached:
I solved the problem by using spry tabs with the bond information on one tab and the payment information on another tab.