One form to enter data, for a lot of tables

[Guest_imported]

I have made a data base with a lot of tables, and within those tables a lot of fields. I would like to enter information in all of the tables using one form, however with the field limits in queries, i cant figure it out. I have also tried to link seperate forms together, (and have them pre fill common info.) with no luck... Any ideas?
Thanks RJC

 

[Uaikega]

You sound like a complete beginner (like me - although I have been at it a little while and think I am getting there!) - actually a complete answer to your question would be a manual in itself - but start by making sure that your tables form a single relational database, and that all the relations, links etc. you want are in place. Then read all you can find in the help files about subforms, and find out how to add them to your form.

At this stage your queries may be a little less general, and forums like this will start to get more helpful.