I've a table(1) with a list of organisations. These organisations are involved with different consultations. I've listed these consultations in another table(2). I've another table(3) with 2 fields (both PK) one with the organisation ID and another looking up the list of consultations. I use this table as the subform for the organisation table and this works okay (I think).
What I would like to do because of lack of space is in the organisation form have a button that opens up a form based on table(3) so that the user can choose from the list of consultations. Cant work it out.
What I would like to do because of lack of space is in the organisation form have a button that opens up a form based on table(3) so that the user can choose from the list of consultations. Cant work it out.
