Skip to main content

I'm having difficulties understanding how to link these two tables and would appreciate a little help.

Table 1 called "Products" looks a bit like this:

MakeLineModelType
DellLatitude123Laptop
DellOptiplex3231Desktop
HPProbookA34Laptop

All the fields are Single Text except Type which is Single Select

Then I have another table called 'Processes' with only two fields

TypeProcess
LaptopBox Assembly
LaptopScreen Manufacture
LaptopPSU Testing
DesktopBox Assembly
DesktopCase Paint
DesktopPSU Testing

On the Product Table, I'd like it to "lookup" the selected product type and complete a field containing all of the processes.

TypeProcess
LaptopBox Assembly, Screen Manufacture, PSU Testing
DesktopBox Assembly, Case Paint, PSU Testing

I'm having trouble understanding how to set this up. Any ideas?

Have you already linked the two tables together?  If not, right click on the "Type" field header in "Products" and convert it to a linked field to the "Processes" table

After that, right click again on the field header and select "Add lookup fields" and add the "Process" field.  Should do what you need

Hello,

I think that you need to create a "Type" table achieve what you want:

 

Then, in your "Processes" table you link the field Type to table Type:

 

Then, you add a lookfield in table Type to list all possible processes:

Then, in table "Products", you link field "Type" to table Type and you add a lookup field to get possible processes from table type:

Regards,

Pascal

 

Reply


Terms & Conditions