Create form from tables

[landonet]

I need to create a form from multiple tables - what is the best way - from the tables or an query - please explain the process or refer me to other documentation - thanks?

 

[Trevor G]

Are the tables related through the relationships window? If yes then create a form based on each table by themselves then with the main form open in design view you can simply drag the other forms into it, so you need to make sure you can see the Navigation pane (Database window), also that there is enough space for each form, if necessary you can add the multiple page option and place the other forms into each page.

 

[landonet]

Thanks for the reply - is it possible to create one form with fields from 8 different tables - only some of the data needs to be updated and i don't want all the fields from all the tables in my form??? Thanks

 

[Trevor G]

Yes as you create each form you just either hide the fields or delete them, that way only the fields you want updating will appear.

You will have to ensure that the related fields are available again they don't need to be shown, you can place them in the form footer and hide the footer.

 

[landonet]

Thanks again, you don't know of a sales database, leads, prospects, pipeline, etc which i can use?

 

[Trevor G]

How big is the company? as microsoft provides a CRM system which can be used with Outlook, if your company has its own IT department you could ask if they have the license?

There is a system called Gold Mine out there which is a contact database (CRM), and no doubt there are a number of others.

Do a search on GoldMine and also CRM systems.

 

[boblarson]

Thanks for the reply - is it possible to create one form with fields from 8 different tables - only some of the data needs to be updated and i don't want all the fields from all the tables in my form??? Thanks

Creating ONE form from 8 different tables is not likely going to produce what you wish. In order for you to be able to update data you need to have a query which is updateable. So, you build the query you want to use for the form and see if you can add/edit records directly in that query and then you will know if you can do what you want.

More than likely what you will need is a main form with subforms to be able to do and display the values. If your tables have any kind of one-to-many or many-to-many type of relationship (not talking Access relationship window here but just the way your data is related) then you will need to have the main form show the ONE side and the subform show the MANY side.

One common error people make is trying to include too many tables into their forms when they are building them (another common mistake is not making sure your data is properly NORMALIZED).