TABLE-TABLE RELATIONSHIP
I am a new user, so my question is very basic. I have 3 tables within a single app. All 3 tables contain the same Last Name field and First Name field. I've tried (unsuccessfully) to create a T-T r...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendCan you tell us how much data is in these tables now and how the future data entry will work? Will the data be imported or will it be entered by hand.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- For the app in question, except for the 2-3 common fields (i.e., last name, first name and maybe 1-2 others common fields), the data will be entered manually. This is an HR app with about 30-35 employees.
Bruce
------------------------------
Bruce Kasen
------------------------------- MarkShnier__YouOK, so the right way to build this app is to leave the key fields as Record ID#. Then build a relationship where 1 Parent has many children. You will need two relationships, one for each of the two child tables.
I suggest making a field on the Parent EE record for Full Name.
The formula would be
List(" ", [First name], [last name])
Then look that field up down to the child table
Edit the field for Related Employee on the child table to set the proxy field to be that Full Name field.
Put that Full name field on the child form and if related Employee was also on the form, remove it from the form.
Set the Full Name field to be a link to the Parent EE Record.
When the user has child date to enter, they will launch off the EE record to add the child and the EE Full name will auto complete. In fact I suggest editing the form properties for the child table form to make that [Full name] field not be editable.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Thank you Mark. I'll try it tomorrow. Have a good evening.
------------------------------
Bruce Kasen
------------------------------
