I want to see and enter mulitple lines in the same table.

[punter]

Hi,

Access newbe here. I have a problem and I hope someone can point me in the right direction.

I have a table that has three fileds (more actually but the theory should be the same). They are:

1-Unique #. This is a number that will be unique to this record. It can be repeated in table.

2-Container #.

3-Cartons

I'm trying to create a form to enter data for those fields into a table. The problem I'm running into is that there may be from 1 to 15 lines for each unique #. That is okay from the standpoint of me being able to run queries and reports. The issue is with the form.

I want to be able to set up as many as 15 boxes for each field on the form. When I enter the unique # it is populating those boxes with the data previously entered. How can I set the form up so I can enter the data for each line without it duping when I enter the unique #?

I hope I explained myself correctly. If I didn't please let me know.

Thanks in advance for all your help.

Eddie.

 

[CraigDolphin]

Sounds to me like you need two tables.
tblContainers
-ContainerID (Autonumber) -> Primary Key
(-Other fields specific to Containers)

tblCartons
-CartonID (Autonumber) -> Primary Key
-ContainerID (Integer) -> Foreign Key
(-Other fields specific to Cartons)

In you relationships table, link the two tables via the ContainerID field and enforce referential integrity.

Make a form bound to tblContainers that has a control bound to the ContainerID field. Make a subform (using the ContainerID field as the child/master field) that is bound to the tblCartons table that defaults to continuous form view and has controls that are bound to the ContainerID and CartonID fields (and any other fields in the cartons table that you might want). You only need one control for each field.

 

[punter]

Thank you Craig. I realized before I got your reply that I needed to create a subform.

You know anything about getting subtotals to work? I have the subform working but now I want to make sure there is some validation on the sheet. I have another thread going if you want to look.

Thanks

Eddie.