question regarding tables and forms

[reena]

Hi,

I have a company table with company ID as the primary key,
And the company can belong to many exchanges,

I have a look up table for exchanges with Exch ID as primary key and Exch Desc as another field.

I have linked the company and look uptable by creating another table called Company_Exchange
With following fields:

Exch ID , Company ID forming the primary key
and other fields are
Suspension date and Suspension Lifted Date.

In the main company form,

I should be able to show all this information in the following way.

Memberships , suspension date , suspensionliftedDate
AME , -/-/- , -/-/-
BOS , -/-/- , -/--

They not only should be able to see but they need to enter information if they want to become members for other exchanges.

I am badly stuck here.
No clue what I am doing.

Thanks in advance

 

[Jack Cowley]

See the answer that I posted on the A3 forum.