1 widget<-->few gidgets

[piri314]

Hi,

My ACCESS schema for one of my widgets table.

I made the one-to-many relation
I made 2 left joins (for the moment) from the widget to 2 gidgets tables.
Except the point that every gidget's element represents one line in the widget's tableView (another post),
I have a real horror in the AddForm : I have 4 values repeated 4 times for the 1st gidget, and 4 values repeated 4 times for the 2nd gidget.

Where am I wrong ?

Thanks,
PIRINA

 

[piri314]

I made the one-to-many relations, because, in the image, the COM_tables are allready full and I would like to have all the joined gidgets elements in the same widgets form.

PIRINA

 

[cheesegrits]

You are talking about one-to-many, but what you have is a many-to-many setup using a linkage tables.

So, for instance, each Dispositif can have multiple Themes, and each Theme can belong to multiple Dispositifs.

If you are using the 'one-to-many' technique we describe (using repeated linked groups), that won't work.

-- hugh