Limit LOCKUP based on previous enter value

[viking123]

I have a database containing three tables
- Table1
- Table2
- Table3

Table1 contains:
- Id
- Manufacture

Table2 contains:
- Id
- Manufacture (LOCKUP from Table1.Manufacture)
- System

Table3 contains:
- Id
- Manufacture (LOCKUP from Table1.Manufacture)
- Systems (LOCKUP from Table2.Systems)


- Note

My question is:
How du I get the field "Table3.systems" to show only the systems which fits "Table3.Manufacture"? At the moment all systems are shown. I would like to limit the list of system, so when I choose fx "Siemens" in Table3.Manufacture, then only Siemens systems appears in Table.systems.

[pbaldy]

Sounds like:

http://www.baldyweb.com/CascadingCombo.htm

[viking123]

Thanks, it was what I was looking for.

I have also found the following link, which also describes a method of due it.

https://www.youtube.com/watch?v=SpMyGlEInGs

[pbaldy]

No problem, and welcome to the site by the way!