Bruce

Post a picture so we can see your report and the query.

-Raymond

Bruce

The easiest of your 2 dilemmas is getting the text for the relationship of the EC. The reason it shows a 1 is because that is what is stored in your table. I'm guessing that in the form where you select that, you have a combo box where you see the text you want but it has a hidden ID field. The ID is what gets stored in your table - which is how it should be. *

In order to see the text in your list, you need to add the second table to your query (Family_RelationshipsT) and in your form, show [Family Relationship] ** in that field instead of [ECRelationship].

* In your EmergencyContactInfoT, ECRelationship should be stored as a Number of type Long Integer so that it matches the data type in the Family RelationshipsT

** You should avoid spaces in your table and/or field names. You'll regret it later as your project progresses. Especially as you add code or macros.

As for you other issue, I'd be interested in seeing your form in design view as it looks like you have set up a continuous form with the Primary Person and the emergency contacts in the same detail section. If that is the case, you would need to split those and have a 2nd continuous form in the footer for the emergency contacts in order to display more than 1 EC.

Don

Just re-read and realized I messed up. I was thinking you were working with a form.

Would still need to see your report in design view to see what's going on. Most likely need the EC's to be in a sub report for each member so that it could pull multiple records.

Bruce

When you're taking screenshots... expand your tables and queries out so we can actually read all the information.

1. Remove the spaced from you Table and Query Names.  This will cause you more problems in the future.

2. In your EmergencyContactInfoT, change ECRelationship to a Number.  This is an ID field and should be named ECRelationshipID.

3. You should not have fields in your Tables just called 'ID'.... give these fields names that tell you what table they're in.

4. In your 'EmergencyContactInfoT Query', this is a bad name for your query.  You're identifying it as a Table and a Query, and you have a space in it.  Change this to 'EmergencyContactInfoQ'

5. Add FamilyRelationshipsT to your query with a Join line between the ECRelationshipID in the EmergencyContactInfoT and the (corrected) ID field in the Family RelationshipsT.

6. Add Family Relationship to your Query.

7. In your Report, remove the ECRelationshp Field and add the Family Relationship to your report.

-Raymond

Bruce

With as many errors I see your your Tables, Fields and Relationship... you really should go back and watch Rick's Beginner series again and try to make your database conform to the conventions described.  You are going to create lots of problems for yourself and it will be very difficult for anyone to help because we have to assume that you're using good database development techniques.

Microsoft Access Beginner Level 1 - Complete 4-Hour Course

-Raymond

Thanks Raymond. I will do all suggested!

Thanks Everyone. I am very new at this!