how to make a listbox depends on another listbox in the same table

[musmoniem]

i need to make a list box field in an access table its value depends on the value of another list box >>
Example a field2 is a list box its values appears depends on the value i chosen from field1 list box ,, so
i made a table for field1 values and another table for values of each value in field1
how could i control it

 

[MajP]

You do not want ANY lookups At the table level. Only forms.

 

[CJ_London]

what you are looking for is cascading combo's - the same principle would apply to listboxes. However as MajP says, these cannot be used in tables which should just store data in its rawest form. You need to use a form - see this link for a demonstration of using cascading combo's https://www.access-programmers.co.u...boxes-in-datasheet-or-continuous-form.275155/