Merge data from two tables into one report
I am looking for help in making a report which will make nametags for the Contact, their spouse and any children associated with them -- each family size is different so some Contacts are single yet ...
Forum Discussion
An alternative is to have one table of contacts and relate it to itself. Quickbase will ask you if you are sure you want to do that, but say OK.
Name the field which connects the table to itself to be called Related Primary Contact.
There will be a way to migrate exiting data from the Child table into the Parent table if you want to go this route.
Another method is to have an automated process to copy to a third table.
But I think having one table might be a better solution.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thanks for the reply, Mark. Going to one table is a helpful suggestion and I think gives me a path to solve this. Thanks!!
------------------------------
Stephen Jackson
------------------------------
