From table to drop down

Sir,

I have two table, i.e name 1) lookup, name of column Name ofthe Country, Name of the State, Gender and 2) entry, name of column Country, State, Name of Customer, Gender. in this time entry table in column name Country equal lookup[Name ofthe Country] use valid_if , State equal lookup [Name of the State] use valid_if, name so name type and Gender equal lookup[Gender] use valid_if. if 1st row are not problem but 2nd row to last not show properly Gender because gender are Male or Female but Country 30 (for example) state 30 (for example). I want to use One table verious type of category for drop down in another table. Please solve it…

With regards

Bachchu Haldar

(PII Removed by Staff)

Sorry, as with your other post, this is not clear. Please explain in more detail or provide images showing what you need.

NOTE: You do not need separate tables for Lookup and Entry. You can use the same table for both.