Create a report from un-related tables.

[Hillary]

I am trying to use Access to simplify the process of creating barcode labels for our products. The problem is I can't figure out how to link the information I need on the report.

I am importing 3 tables, each with only 1 or 2 fields and I am manually creating a list for Supplier. These are just lists generated from SQLTalk. These tables will continue to be updated periodically. The tables and fields are...
[ul][li]Parts - Part, Description[/li]
[li]Supplier - Supplier[/li]
[li]Line - Line[/li]
[li]Location - Location[/li][/ul]
I have already created a form that allows the user to use a combo box to select each of the above through unbound fields. Unfortunatly, I don't think the report can be based on these unbound fields. I think the report must be based on a Table or Query.

Does anyone have an idea on how I can create the report?

Thanks for your help.

Hillary

 

[RiverGuy]

Does a line have a part?
Does a part have a supplier and a location?

If so, then the tables are related. You might not have defined relationships in the relationship window, but to see different attributes of an object that are in different tables, then there are relationships.

If you have your keys set up right, then open a query, add all those tables and draw lines between the corresponding fields in each table.

For example, Line should have a PartID field. Parts should also have a PartID field. Draw a line between them. This creates an inner join. You'll only get records where there is a part that does exist in a line. If you have lines with no parts, then you would need a left outer join.

Anyways, make your relationships in a query, and pick the fields from all the tables you want, then base your report off that query.

 

[josephwalter]

Create an unbound Report.
Drop some text boxes onto it.
In the Control Source property put:
Forms!frmMyUserInputForm.cmbMyComboBox.Value.

* frmMyUserInputForm is the name of the form your users see.

* cmbMyComboBox is the name of the combo box you want the text box's value to display.