G
Guest
In the following example I realise I could have one table "Contact Details"
but if anyone can advise on my question, it woud be much appreciated.
If I have 4 tables:-
Client Name: ID, FirstName, LastName (Text)
Phone Numbers: ID, Number(Text)
Mobile Numbers: ID, Number(Text)
Email Address: ID, Address (Text)
If I have setup relationships to reflect any one client has many Phone
Numbers, many Mobile Numbers and many Email Addreses......
My Question
Can I create one "Data Entry Form" to enter data into the tables or do I
need to create a separate Data Entry Form for each table. Using the Form
Wizard or doing it manually appears to only allow me to select one table
source at a time (I thought I would be able to incorporate the fields from
all table on the one form.
I know this may not be a great example to use but I am trying to understand
the methods available to enter data into serveral "Related Tables" as
compared with a "Flat Table"
Thanks in advance for any advice.
but if anyone can advise on my question, it woud be much appreciated.
If I have 4 tables:-
Client Name: ID, FirstName, LastName (Text)
Phone Numbers: ID, Number(Text)
Mobile Numbers: ID, Number(Text)
Email Address: ID, Address (Text)
If I have setup relationships to reflect any one client has many Phone
Numbers, many Mobile Numbers and many Email Addreses......
My Question
Can I create one "Data Entry Form" to enter data into the tables or do I
need to create a separate Data Entry Form for each table. Using the Form
Wizard or doing it manually appears to only allow me to select one table
source at a time (I thought I would be able to incorporate the fields from
all table on the one form.
I know this may not be a great example to use but I am trying to understand
the methods available to enter data into serveral "Related Tables" as
compared with a "Flat Table"
Thanks in advance for any advice.