Form doesn't update multiple tables

[Chicco]

Hi all folks,

designing the ER diagram for the DB I'm working on and investigating on the nature of each entity I thought it was a good idea to have a number of LOOKUP tables to save space and to allow for future expansion on items type.

Also, I thought would have been nice to use the TABBED control to have related entities nicely paired.

Armed with some good advice, I started designing a form giving it a QUERY as a ROWSOURCE.

Within one (or more in the future) tab, I would need to select static values
from comboboxes to choose a number of parameters.

The two pictures I enclose depict:
1) The form layout and the tables sourcing data to controls
2) the relationships among DB tables

Well, with the form depicted in pic.1 I tried in every way but no way to get the involved tables update or (which is worst) not even select from comboboxes.

After investigating here in the forum and over the net, I understood my form design approach is not the right one and I should stick with SUBFORMS.

Anyone willing to address me toward the right approach or tell me what I'm doing the wrong way?

 

[Chicco]

Hi all again,

I've solved my problem and now I have a form which does exactly what is intended for.

In order to achieve this result I undertook a new form design, as per following
steps:

1) form design has been based on AN_VEICOLI tables.
Since this table is related to DOCS_VEICOLI table, when the form appears on wizard completion it shows also DOCS_VEICOLI related record, but as "datasheet".

2) I completely removed my lookup tables and created two new fields
for fuel type e vehicle type within AN_VEICOLI table.
These fields allows for selection of each possible combination of the above
attributes and therefore, on the form, appear like comboboxes.

3) I created a tabbed control with two pages and copied in one page basic
vechicle information and in the other the vehicle's documents data.

4) since what I wanted was a tabular visualization and not the datasheet one, I removed the datasheet and via the "Add existing fields" added again
related fields.

Now everything works fine and the form shows and updates data.

Maybe this is not the best method to follow but it worked for me.

If anyone want to give further advice, you are wellcome.

Thanks in advance for any reply/help

 

[isladogs]

Its definitely better & not just because it works!

Using lookup fields in tables is a bad idea. They make it very difficult to track the underlying data & can therefore lead to errors.
You made the right decision in scrapping them

Similarly I strongly recommend you NEVER use multivalue or attachment fields.