Auto Insert

[WhiteRaven]

i've basically got 2 tables, table1 with 2 columns called "OrganisationName" {PK} and "ContactName". table2 has 3 columns "OrganisationName" linked to the 1st table, "ContactName" also linked to table2 and "PhNo". i've created a form with txtboxes "table1.OrganisationName", "table1.ContactName" and "table2.PhNo". what i'm after is that everytime i add something to table1.OrganisationName, it gets added to table2.OrganisationName as well. same with "ContactName". i can't seem to do this even though the tables are linked together. how can i do this through a form?

 

[mohammadagul]

hello whiteReven

Create a Form using
"Create Form By Using Wizard"

Select all rows from from table 1 and table 2. Access will automatically suggest you how to make you form using the wizard. carefully forllow the steps in the wizard and you will get a form with a subform in it. try inserting data in Organisation name field . you will notice that the same data is also in the subform.

Note: the main form will be based on table 1 and subform will be based on table 2.

 

[WhiteRaven]

when i create a form by wizard, i add all attributes to the form (from both tables), it asks for what layout, style, and title for my form. there isn't any option that could change the layout....