Want data from form to post to table.

[kkershaw]

Now that I have successfully got my combo boxes to copy data to text boxes in my form (thanks to fizzio), why won't that data now appear in the related table?
Example: 'rate' copies from a combo box to a field named 'rate' on my form. When I go to the table, the 'rate' column is blank. I need the table for my reports. This affects several fields in my table/form. Please advise.

 

[David R]

Where does your combo get the rate from? That is where you get the rate from for your other reports, etc, unless your rate data is subject to change and you need to keep point-of-time records of what rate applied when (for example, invoices/receipts).

Storing the same piece of data in two places, when you can get it at any time from the original source, violates database normalization rules.

Post back if you need further assistance,
David R


[This message has been edited by David R (edited 04-16-2002).]

 

[kkershaw]

Each form represents an actual bill of lading, so I do need to store the rate with the form, and have it in the underlying table so that I can create reports. Currently, I get the rate from a query based on a table. The rates are linked to a field called OriginDestination. These rates are subject to change from time to time.

Thank you.

 

[David R]

http://www.access-programmers.co.uk/ubb/Forum4/HTML/006525.html