One Form Multiple Inputs

[Cat_129]

Hey, I know this has a simple answer but really cant remember how to do this. Still attempting to move the majority of our forms / logs / etc to access

I have a form that someone fills in, the form will relate to multiple part numbers.

Currently we use excel so you have the main details at the top and then use as many rows as required.

How do I move this form over to access?

I have the top part sorted and the form number will be the primary key. Its how does a person enter multiple part numbers within a singular form.

Thanks,
Cat

 

[CJ_London]

not enough info to provide a more accurate response but with access the principle os one form one table. To reflect a 1 to many relationship (from your description, the form number is on the one side, the part numbers on the many side) you would use a main form for the 1 side and a subform for the many side

 

[Cat_129]

The best way I can think to describe my problem is a like a customer order.

The customer details are the top of the form and the order details are at the bottom,

The order will have multiple items all of which need to be linked to the information at the top of the form.

I was thinking a form in a form, or am I over complicating?

Sorry if these are stupid questions.

Thanks,
Cat

 

[CJ_London]

the form in a form is a subform.

in the context of orders you might have multiple tables and multiple subforms.

for example you might have the following tables

customers
customer addresses
products
order header
order lines

the main form would use order header
you would have either subforms or comboboxes for customer and customer addresses depending on complexity of your business
order lines would be on a subform
products would not need a subform because it would be referenced via a combo in the order lines subform

 

[arnelgp]

I have the top part sorted and the form number will be the primary key. Its how does a person enter multiple part numbers within a singular form.

you need two tables there.
the header and detail table.
form number, PK = yes.
add an autonumber field.
try adding other "common" info like, date this form (invoice) is made.
which customer, delivery type, etc.

the detail table:
it must have a, Long numeric field (this will hold the autonumber of the header table).
other info, such as partnumbers to be invoiced, qty, amount, etc.

create a form for the detail.
add this form (as subform) to the header (main form).
on it's property->Master Link Fields/Child Link Fields, set it to autonumber(of header) and the Long numeric field on the detail.

 

[Cat_129]

Thanks for the advice guys, will give it a go and let you know how I get on.