subform based on 1 table?

[afs24]

How do I use a combo box to pull up information for a customer in a subform? All of the information is in one table opposed to two or more. Usually, when you create a subform you have to link the child and master fields. I just want the user to be able to scroll through all of their information in a spreadsheet type form but all the data is contained in one table. Can I do this?

 

[Parra]

If you only have 1 table in the database, then you don't need a subform. Just pick the fields you need to view for the form. Kinda like choosing which fields you need for a query. Or you can create a form of a query.

Parra

 

[afs24]

I have about 5 feilds but there is a lot of data and that's why I want some sort of spreadsheet view to scroll through all the data.

Example:
customer Auto Inc is my combo box selection

item store units
100 16 11
100 26 10


There could be 100 plus entires the what I have above. I need something user friendly on the form.

 

[Joe4]

You can set up a form to display in Datasheet View. You can move certain fields up to the Report or Page headers if you don't want them repeated.

Also, be sure that your tables are normalized. You may need to split up your table into multiple tables. If your table is not set-up in at least Second Normal form, you will find that projects like these may be problematic.