Having problems with link/lookup

[bitstreams_red]

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:

Make	Line	Model	Type
Dell	Latitude	123	Laptop
Dell	Optiplex	3231	Desktop
HP	Probook	A34	Laptop

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

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

Type	Process
Laptop	Box Assembly
Laptop	Screen Manufacture
Laptop	PSU Testing
Desktop	Box Assembly
Desktop	Case Paint
Desktop	PSU Testing

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

Type	Process
Laptop	Box Assembly, Screen Manufacture, PSU Testing
Desktop	Box Assembly, Case Paint, PSU Testing

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

[TheTimeSavingCo]

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

[Pascal_Gallais-]

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