Hey I was wondering if you have any suggestions. I'v been stuck on this for a while.
Here's what I have so far:
5 tables: Each table has 10 feilds, Name, money, date1, pay1, date2, pay2 Ect
*The same person can come up in multiple tables*
Example:
Table 1 could have 3 people each with their own Name, Money, date1, pay1 ect
Table 2 could have the same 3 people, but with different Money, date1, pay1 ect
My question is, how do I create a form, in which I am able to search for a name, and It shows me the information about that person from both tables.
So I should have:
Person1 - Money, date1, Pay1 (From table 1)
- Money, date1, Pay1 (From table 2)
- Money, date1, Pay1 (From table 3)
The tricky part is, I need to make more tables with Money, date1, Pay1, In the future so I need to be able to add a new table, with the same fields as the other ones, and have to show when I search for that persons name.