Making one form input to many tables

[mdlister]

Hi there, i have a database i am setting up with 4 tables and am trying to think of the best way to input new data into it. All the tables are linked and its all based on printers. When a new printer is brought if it exists in the database then thats cool it just needs a Printer number assigned to it and the database will do the rest looking up printer model and what cartridges it requires. But if u add a model for a HP printer for example you need to add the model number to the tblink and create new cartridges and use the cartid to link the modelID i hope u get the picture!? lol there is a pdf i have created using onenote with screen dumps and comments about what i need it to do. If anyone has some advice or help it would be very greatful! Thanx mike

 

[Malcy]

Hi
Sorry haven't looked at your attachment since short of time but you need to logically work out the processing steps and then build a sequential structure of queries which you call on order, either using a macro or more constructively using VBA.
You can refer to textboxes on the form whilst the form is still open, and can add them to wherever you want but I think you would need to use VBA probably since you will need to pull back the ID for added fields as a variable to create the record in your links table.
Draw it all out then build it up and test step by step.
Good luck