Hi Guys,
Nearly getting to the end of application with your help, I have a problem when writing the reports. I will try to explain my problem.
I have a form that creates a Weighbridge Docket, this form is called Touchscreen. It store Data in a table called Docket.
On this form I have a listbox Materials, it takes it's value from the Table Materials when clicked. I have a relationship between the ID's of Docket and Materials. The two other fields in the materials table are "buyprice" and "salesprice" when I work with current reports, it takes the value from the table materials. I can't use these values directly from the table materials as the price changes every so often. So I have to write these value's into my table Docket, so when making a report on i.e. Material Stock and the amount paid for the materials is equal to the real amount and not the last value's entered in the Materials table.
In short, could someone help me with some code that would read the buyprice value from the field in table Materials, and write this value in the buyprice field of the table Docket when a material is chosen from the listbox125.
Any help greatly appreciated..
Nearly getting to the end of application with your help, I have a problem when writing the reports. I will try to explain my problem.
I have a form that creates a Weighbridge Docket, this form is called Touchscreen. It store Data in a table called Docket.
On this form I have a listbox Materials, it takes it's value from the Table Materials when clicked. I have a relationship between the ID's of Docket and Materials. The two other fields in the materials table are "buyprice" and "salesprice" when I work with current reports, it takes the value from the table materials. I can't use these values directly from the table materials as the price changes every so often. So I have to write these value's into my table Docket, so when making a report on i.e. Material Stock and the amount paid for the materials is equal to the real amount and not the last value's entered in the Materials table.
In short, could someone help me with some code that would read the buyprice value from the field in table Materials, and write this value in the buyprice field of the table Docket when a material is chosen from the listbox125.
Any help greatly appreciated..