I have imported three sheets from Excel that are related, i.e they have the same unique column index in each sheet.  Had to split my data into three since I had too many columns for Creator.

On importing into Creator I want to link / join the forms together so that I can create a report that has all the information in one view.  (From reading the help sheets I need to create a relationship to do this.  Lookup or Subform.)

So, on the Members form, which has all the contact information of a member, I have a field called "Application Number" which is unique to each member.

I then have an Addresses form which currently contains one address for each member with again the "Application Number" as the unique field.  each member has one address associated with them.  (Once I have the application up and running I want to add more addresses for mailiing address, post address etc.)

I then have another form which has the Employer details of the member.  Again, it has the "Application Number" as the unique reference.  

I have tried adding lookup fields into the forms to create relationships between the forms but that does not really do what I want since as a dropdown it allows all records in the associated form to be displayed whereas I just want the record that has the same "Application Number" displayed.

I am at a loss as to how to make this work.  Any suggestions would be gratefully received.  Again, first post to this forum so be kind!

Regards,

Chris.