Solved Automatically Updated and Expand Text Field

[m_sami9]

Dear Seniors,
Hi,
Im not good in English. But please understand my question. I've a product sales database. I entered product code and it's automatically fetch data from table. I make a invoice with product code and invoice created.

When I entered code of products another text field automatically fill with product code. Just like I entered product code 5, another text field fill with 5. After that I entered product code 8, another text field fill with 5 and 8 (5 8) and after I entered product code 12, another text field fill with 5 8 and 12 (5 8 12).

Please guide me.

Thanks

 

[arnelgp]

you use Query that joins your "transaction" table to your "product" table (via product code).
you then return all fields from trans table and the "other" field (maybe description or price) from
your product table.

 

[m_sami9]

Please check the attached as I desired (I want in database)

 

[m_sami9]

I did it,
please check it

 

[arnelgp]

you're goal is to create invoice?
see this simple demo on what you need to do.