Autofill form

[ukmale65000]

thanks Alan

 

[Alansidman]

Changed your form for the dealer to a regular form from a data input form. I see what you mean by the data not populating your table. But when we changed the way you enter data for a dealer to a combo box, all the pertinent data is stored in the dealer table. You do not need it in the other table because if you need to retrieve it then you would use a query to join the two tables and extract the data based upon the dealer ID. You can probably delete the fields from the main table. I don't recall if I suggested you read this white paper on data structure and normalization. If I did, then my apologies, if not, then I think it will be beneficial in understanding what is happening here.

http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx

 

[ukmale65000]

Any idea why the form for populating the original table is not creating a new record every time?

 

[Alansidman]

What do you need in it to populate that is not there? It appeared to have all the data necessary. Your forms are complete. If you run a query and have the two tables joined you will get all results. Any additional data would be duplication and contrary to RDBMS normalization. What do you believe is missing?

Alan

 

[ukmale65000]

Sorry alan just that when i tried to run the collect form and ticked either the collect from this address or deliver to this address boxes they remained blank. As i said im trying to understand access and found that if i copied the dealer address in the tbldealer table you created then paste the information to tje collectaddress and delivetaddress fiwlds in the tbldealer then i filled in the collect form this time the tick option worked fine hence me asking if tje data could be autofilled to prevent me cutting and pasting.
Also i cant crack creating a new record rather than overwritting the first field in my original table when i conplete the collect form.
Sorry if this all seems a bit trivial.