TableA
- A_id
- A1
- A2
- FK_B_id
TableB
- B_id
- B1
I have a form displaying TableA and I want FK_B_id to be a dropdown when adding a record. In the dropdown tab in the objects page for FK_B_id I have added the following SQL code:
Code: Select all
select B_id from TableB
What am I doing wrong???
Thanks