Wrong ID recorded in table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables, one is PaymentMethod and other is PurchaseOrderDetails.

In the PaymentMethods table I have the following fields & data
PaymentTypeID PaymentType
1 (blank)
2 American Express
3 MasterCard
4 Visa
5 Cash

In the PurchaseOrderDetails table I have field name PaymentTypeID. This
field record the ID number when user selects in form.

My question is when I open the PurchaseOrderDetails table for viewing, I
found that all my PaymentTypeID shown one value lower than the actual ID
number. (i.e. 3 should be Mastercard but it is recorded in the PaymentTypeID
as 2 in the PurchaseOrderDetails table instead of 3

Anyone know what is causing this problem?
Thanks
 
Presumably you have a form bound to the PurchaseOrderDetails table, and this
form has a combo box bound to the PaymentTypeID field.

Open the form in design view.
Right-click the combo, and choose Properites.
You should see properties set like this:
Control Source PaymentTypeID
RowSource PaymentMethod
Column Count 2
Column Widths 0
Bound Column 1
 
Thanks, the Bound Column set to 0 instead of 1.

Allen Browne said:
Presumably you have a form bound to the PurchaseOrderDetails table, and this
form has a combo box bound to the PaymentTypeID field.

Open the form in design view.
Right-click the combo, and choose Properites.
You should see properties set like this:
Control Source PaymentTypeID
RowSource PaymentMethod
Column Count 2
Column Widths 0
Bound Column 1
Click to expand...
 
Back
Top