AnsweredAssumed Answered

Relationships

Question asked by HB on Jan 5, 2012
Latest reply on Jan 6, 2012 by philmodjunk

Title

Relationships & repeating fields

Post

For each item in a repeating field, I need to show uptodate data in a related table that will only have one record for each of these items.

 

In more detail, I have a premade database system (very complicated, one that I cannot delete its design - only add features & fields & tables etc). Among many others, it contains:

File called Data01 containing a Table WO, which contains Fields WONum &  PartNum(10)  (10 max repeating fields)

File called Data02 containing a Table PC, which contains Fields PartNum(1) & Loc

File called WO containing Layout WO.

 

In Layout WO, I have inserted the field Partnum(10), so for each WO, it shows the PartNum(s)

& I want it to show the location which is in Data02 for each as well.

 

I tried lookup fields, but it doesn't stay up to date if the data in Data02 changes.

 

I tried to setup relationships too, but when I insert the Location field into the layout, it only allows for 1 repeating field max. & the data is empty.

 

Please help me establish the correct relationship.

 

Thanks in advance.

Outcomes