moleygunn
Apr 28 2005, 10:04 AM
How do I make it so that when I add a new record to the 'Customers' table my DB will add a record with the same primary key to table 'Jobs'?
It's pretty basic stuff I suppose, but I don't know how. I'm using forms.
Scott
xteam
Apr 28 2005, 10:08 AM
You may try to use a subform (bound to Jobs) placed on the main form (bound to Customers)
moleygunn
Apr 28 2005, 10:18 AM
That's what I have, but it's not working. I want to allow for more than one job per customer. So CustID could be 66 and that would apply to jobs (JobID) 70 and 71.
Any ideas?
xteam
Apr 29 2005, 12:31 AM
It should work. You have to have CustID as Foreign key in Job table.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please
click here.