Blank Fields

[billgyrotech]

hjsdkgkkkkkgggg

[June7]

No data shows because the textboxes are bound to Workorders MakeAndModel and ItemDescription text fields but there is no data in those fields. You have saved the Make/ModelID and MMDescriptionID values in Workorders so to show the text descriptors must include Make/Model and MMDescription tables in the report RecordSource.

There is no reason to have both ID and descriptor fields in the Workorders table. If you want to save the text descriptors then make those fields the PK and remove the autonumber ID fields from tables and comboboxes.

[billgyrotech]

I really don't know how to do this without messing up what functionality exists.

Could you please lead me in the right direction?

[June7]

Just include Make/Model and MMDescription tables in the report RecordSource and bind textboxes to the text descriptor fields from those tables. Probably don't want INNER join. Change to LEFT or RIGHT (I think RIGHT) by selecting "Include all records from Workorders ...".

[billgyrotech]

It sounds easy for you to do that. I am a novice and every time I try correcting this problem I have to revert to an earlier version.

[June7]

How did you create the RecordSource for the report to begin with? It is just an SQL statement in the RecordSource property. Select the property and click the ellipses (...) to open the query designer. Add tables and fix the joins as described and save.

What are you doing if not that?

[billgyrotech]

I started this from a template and manipulated some of it for my needs but I do not know all of what is going on.

All that I need fixed is these 2 blank fields.

[June7]

You have two options:

1. fix the report RecordSource query as described

2. save the descriptor text in Workorders table, this means modifying combobox RowSource to eliminate the ID field and binding combobox to the Workorders descriptive text fields instead of the number fields that hold the ID values

This is all very basic Access functionality and must be learned if you want to develop a database. Building a db (not your real one) from scratch with a tutorial might be a productive exercise for you.

[billgyrotech]

Okay great I am not much better off now. I give up!

[June7]

Sorry about that. Don't know how I can make the instructions offered any more specific.

It is essential to have an understanding of relational database principles, Access functionality, and programming concepts to effectively build a database.

If you don't even know how to build a simple query with the query designer tool, you will be severely handicapped in any effort.

[billgyrotech]

I have the 2 fields populated with Make/ModelID and MMDescriptionID. Why can't these show the descriptions and not the numbers?

[June7]

Because the Make/Model and MMDescription tables are not included in the report RecordSource query so the text descriptor fields are not available to the report.

The corresponding text fields in Workorders table do not have data.

Table relationships are established by links between primary and foreign key fields. If additional data is needed from records of related tables then they must be joined in a query by linking on the PK/FK fields (hence the term 'relational database').

[June7]

Members are not removed from forum because threads are linked to them.

Hate to leave you with an unresolved issue. I hope you understand this site is not in any way associated with Microsoft. It is a private enterprise supported by volunteers offering benefit of our experience (often gained by trial and error).

What is it about the offered instructions do you not understand? How will you fix the problem if you don't know how? For option 1 solution:

1. open report in design view

2. select RecordSource property

3. click the ellipses (...) next to the property to open the query designer

4. add the two tables to the table window, set links between the ID fields, join type "Include all records from Workorders ..."

5. drag the two text descriptor fields to the field grid

6. close the designer

7. select the textboxes on report and change ControlSource property to bind to the two new fields just added to the report RecordSource

If this guidance is not adequate what is it you expect from us?