If LookUp Fields not recommended then?

[cap.zadi]

Hey there, i have go through some articles that "LookUp" fields are not recommend at table level so what should be the recommended way out to manage data?

Like i have a tablMachines

PK ID
Machines


FK DeptID frm tblDepartment.

so what could do at the time of data entery at form level?


thanks

zee

[RuralGuy]

Lookup's with ComboBoxes on *Forms* is just fine, just not at the table level.

[cap.zadi]

Well, thanks for confirmation then how to do that as so far i was used to manage in datatype "lookup Wizard" and select the concernt table as above the DeptID.

So can you advise, how to do it?

thanks

zee

[RuralGuy]

The ComboBox wizard can set it up for you.

[cap.zadi]

Hey Sir,

i am sorry to bother you again beacuse i was not clear about that.

I have the table:

EmpID PK
EmpName
Position FK to table positions.


So when i am going to create form for that table how to have combobox for the position atribute?


thanks


zee

[RuralGuy]

As I said, the ComboBox wizard can assist you with that task.