text field

[nashr1928]

I have a text field in my service report that is called equipment name. The symptom is not all data shows from one page to the next. The form that generates the text have data in that field on all records. The table has all data in that colunm and the query has all data needed. I have looked at this til Im blue in the face and cant seem to find the issue. Im using xp-pro and access 2003.

[RuralGuy]

Are you saying the controls at the bottom of the page should have data in them? Are they bound to fields in the RecordSource of the report? What fields and what are the field types? Post the SQL for the RecordSource of your report.

[nashr1928]

I think I know whats wrong but dont know how to correct. Attached is FORM which is where data originates from combo box pull down named equipment name. This goes to table 2. The relationship from table 2 to table 1 doesnt seem to work.

[RuralGuy]

Are you saying the controls at the bottom of the page should have data in them? Are they bound to fields in the RecordSource of the report? What fields and what are the field types? Post the SQL for the RecordSource of your report.

How about answering the questions I posed please.

[nashr1928]

The field in question is named EQUIPMENT NAME. It is bound.

[RuralGuy]

Post the SQL view of the RecordSource of that form please.

[nashr1928]

This is equipment name that is delivered to a table named STATUS ID.

[nashr1928]

Yes that is correct.

[RuralGuy]

Are we in the same conversation? Is the RecordSource of the form a Query or a Table?

[nashr1928]

The record source is a table named status. I tried linking the status table relationship to the main table named assets1 which is the attachment named table1 but doesnt work out.

[RuralGuy]

If the field you want to display in not in the RecordSource of the form then it will not display in your form. The RecordSource can be a Query that has more than one related table joined together. You need to define your relationships in the Relationship window. Do you have PrimaryKeys on other tables as ForeignKeys so Access can determine the relationship?

[nashr1928]

Yes both tables have primary keys. I already have a query so I will try working on this as query and not table. I will post the results. Thanks.

[RuralGuy]

Remember, the PrimaryKey of the One side of a relationship need to be in a field of the Many side of the repationship as a ForeignKey so Access will see the 1:m relationship when you create the Join.