- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 29, 2024 02:33 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 29, 2024 05:58 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 29, 2024 07:28 AM
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
