Solved how to create a relationship where columns depends on another column

[atzdgreat]

OBJECTIVE:
To create an entry in table where Business Unit Column will depend on what is inside in Organization Column. Same thing in Business Unit Code,

TABLE:

Organization	BusinessUnit	BusinessUnitCode
X Org	Finance	FIN
X Org	Payroll	PYR
X Org	IT	IT
X Org	Surveillance	SRV
Y Org	Test BU	TB

TbleEntry (for data entry)
an example to this is if i am going to select Y Org in Organization. BusinessUnit available list should be Test BU.

but when i used to click the option in BusinessUnit. it give me all the the BusinessUnit.

same thing in BusinessUnitCode

 

[arnelgp]

you need to use a Datasheet Form.
see Table1 form.

 

[plog]

First and least, you don't do this in a table but in a form. The term to search this forum for is 'cascading drop down'

Second and most importantly, this shouldn't be done at all because you are storing data improperly. You shouldn't be duplicating data in tables. If organization\unit\code live together in one table but needed in another you assign a primary key in the main table and then use a foreign key in the table you want to assign organization\unit\code to.