Label printing problem

[igiatakis]

Hi, I have the following problem.



I need to print text labels for certain items. This text is a combination of different phrases, depending on the item. When I have a sales order I need a report to give me the item number, the quantity, and the text label that I should print. For example I have products A, B, C and D. I have two different texts: Text1:"This product contains small parts" and Text2:"This product contains batteries"

I know that Product A needs text 1 and 2, B needs 2 only, C needs no text and D needs 1.

The input is the sales order, Product A:100pieces, product B:0 pieces, product C 200 pieces, Product D 100 pieces.

The output should be a table with the number of labels and the text:

|------------------------------------
| Qty | Text
| ------------------------------------
| 100 | "Product A"&" Text1"&"Text2"
| 100 | "Product D" & "Text1"
| ------------------------------------

How should I build this database?

Thank you!

[NTC]

I would recommend that you make a TextTable. One column. No key. and enter into it each text phrase. Also do not use the method of joining phrases - instead consider them each unique. Thus:
Text1: This product contains small parts
Text2: This product contains batteries
Text3:This product contains small parts This product contains batteries

In your ProductTable - have a ProductText field, and make it to be a LookUp field of the TextTable. This makes it simple to create Products.

Then you need a TransactionTable that is where you get product quantity, orderID, etc - and it has a Product field that is a LookUp Field to the ProductTable. In this case the lookup function is only going to store the unique key ID of the product.

Hope this helps.

[igiatakis]

Hi,

Creating all possible combinations of texts is not the best solution because unlike this simple example there are so many different texts, imagine how many different combinations you may have. In addition it is much easier to update the database if somehow there a list of items and a correlation with the texts that these items require, instead of writing the complete text every time.