S
Silver76
Hey guys,
I have multiple tables with multiple forms all tied in with nicely laid out
swtitchboards (hmmm i was impressed i could do that).
I have just enabled the relationships between forms to tables where i now
key in data to my form and it populates the table in question.
My problem now is that when i create an entry for one table it does not
designate the id number for all the other tables.
Two Tables = Two forms
Table One = Fields - ID / Date / QA = Form One
Table Two = Fields - ID / Date / Customer Service = Form two
I basically give a rating between 1 and ten for each
When I create an entry into Form One it does not automatically add that
record ID number across all tables even though i havent filled out Form Two
as yet.
I would like to be able to create a record in any form/table that
automatically allocates that ID number to all tables/forms whether or not i
have keyed in the information relevant to that ID number on other
tables/forms.
If more information required please ask i feel like i have mountains of it lol
Russ
I have multiple tables with multiple forms all tied in with nicely laid out
swtitchboards (hmmm i was impressed i could do that).
I have just enabled the relationships between forms to tables where i now
key in data to my form and it populates the table in question.
My problem now is that when i create an entry for one table it does not
designate the id number for all the other tables.
Two Tables = Two forms
Table One = Fields - ID / Date / QA = Form One
Table Two = Fields - ID / Date / Customer Service = Form two
I basically give a rating between 1 and ten for each
When I create an entry into Form One it does not automatically add that
record ID number across all tables even though i havent filled out Form Two
as yet.
I would like to be able to create a record in any form/table that
automatically allocates that ID number to all tables/forms whether or not i
have keyed in the information relevant to that ID number on other
tables/forms.
If more information required please ask i feel like i have mountains of it lol
Russ