to data liste

[ali]

Ý have a little problem.
Ý created a data base. There are three columns: product name, product code
and price.
For example:
Product name: acetone extra pure
Product code: 1.00013.2500
Price: 15 euro

Between two dot (00013) to present the acetone extra pure.after last
dot(2500) to present the pack (2,5 lt).
There are a few pack; 1000(1 lt), 0100(100 ml)
Now, the question

Ý have to create a form. The form must has a text box. i want to write 00013
in the box then listed all of containing 00013 data at the sub form.
Or i want to write the acetone then must listed all of containing acetone
data at the sub form.
Thanks a lot for your help

 

[John W. Vinson]

? have a little problem.
? created a data base. There are three columns: product name, product code
and price.
For example:
Product name: acetone extra pure
Product code: 1.00013.2500
Price: 15 euro

Between two dot (00013) to present the acetone extra pure.after last
dot(2500) to present the pack (2,5 lt).
There are a few pack; 1000(1 lt), 0100(100 ml)
Now, the question

? have to create a form. The form must has a text box. i want to write 00013
in the box then listed all of containing 00013 data at the sub form.
Or i want to write the acetone then must listed all of containing acetone
data at the sub form.
Thanks a lot for your help

One basic principle of relational databases is "atomicity" - each field should
store ONE fact. Your Product code stores three distinct facts.

I'd suggest having three fields - Products (e.g. 00013 as "Acetone extra
pure", 00014 as "2-butanone USP", etc.), Packs, and whatever the 1 represents.
It's easy to *concatenate* them for display purposes. If you do so then your
subform could be linked to the ProductID (the 00013) rather than the
concatenated product code.