need advice on structure

[tyb]

Dear frends plz help me.

i want an order entry form where my order data is as below
One PO contains multiple STYLES. style contains multiple
COMBOS. and a combo has multiple SIZES.

if i do simply normalize it and have four tables.
it requires the data entry operator to save the things in the sequence PO,STYLE,COMBO,SIZE.
can any one advise me some sort of structure in which the user is able to enter data with out much hassle.

best regards.

 

[tyb]

sorry for i was missing some information i.e. table realtions are as below

PO & STYLE is in 1 to many
style & COMBO 1 to many
style & size 1 to many
combo & size many to many

e.g.

PO# STYLE# COMBO SIZE
____________________________________
01 159 PAECH X XL 2XL
TEAL X XL 2XL
RED X XL 2XL

160 TEAL S M
BLACK S M



BEST REGARDS.

 

[lewisp]

It looks to me like the STYLE table is the intersection entity between COMBO and SIZE.

Forms has built-in relationships to handle your structure. Build a form with four blocks and create three default relationships: PO to STYLE, STYLE to COMBO and STLYE to SIZE. Forms will automatically create the necessary triggers to keep all your data in sync. You will not need to create a relationship between combo and size, as the ones you create from style to combo and from style to size will suffice.

 

[tyb]

Dear Lewisp

Istly thanks for ur response.

But the problem here, for which i wanted the solution is that if i have four tables/blocks. the user needs to run into hirarchy i.e. Ist parent then child.

but user may like to enter the
PO then One style then the Colors in that style and then SIzes and their quantities.

again for the second style they would be coming back to the styels block then colors and then sizes etc.

i wanted advice on the structure of the table or the items to use which will make it easy for the user (as i'm using sequences for the PK hidden field).

as for the relationships, ican do it manually too.

plz if u have some sort of sample form it would be a grt help for me.

best regards.