2003 Orders Management Template

[Scoop]

In this template:

http://office.microsoft.com/en-us/templates/TC010185481033.aspx?CategoryID=CT011217631033

Can someone tell me what is making the "Customer Name" as opposed to
the "CustomerID" appear in the main form (I think it's called "Add or
Edit Orders")?

Similarly, what is making the "Product Name" as opposed to the
"ProductID" appear in the subform?

 

[Albert D.Kallal]

Can someone tell me what is making the "Customer Name" as opposed to

the "CustomerID" appear in the main form (I think it's called "Add or
Edit Orders")?

In ms-access, you can build a combo box on a screen. Use the wizard to build
your combo boxes. You can select 2, 3, or even 5 columns to display in the
combo box. However, ms-access will store (hide) the first column, and
display the 2nd column you choose.

This is a VERY common database requirement. So, that combo box was built
using the wizard.

You can also build the combo box manually,...just make sure you set the
column length to 0 for the first column (then, this id will be hidden).

open up the form in design view...and click on the combo box., then view the
properties sheet....look carefully through the settings used in the data
tab.

Similarly, what is making the "Product Name" as opposed to the
"ProductID" appear in the subform?

Same again....just use a combo box.

Once again, if you not done this...just build it using the wizard. Make sure
your first column is the "id" of the table (primary key)...and then select
as many additional columns you want to display when you drop the combo (the
2nd column will be the one that display when you select a value).

note that you could use a dlookup function..but that would not let you
select a value. And, you can even build a sql query, and base the form on
that, and you would not even have to use a combo box...

 

[Scoop]

Thank you! I will play around with it. It was driving me crazy. I
suppose that the alternate methods you mentioned (i.e. using a query,
etc.) would have been easier to track down.

In my situation, I was trying to figure out how it was done b/c I
copied/pasted the form to another DB that has tables/fields by the same
names and I know that the source records are "seen" by the form but I
was getting different information than expected in the drop-downs.

Would this happed b/c I don't have the fields (columns) in the same
order in the other DB?
Also, is between the combo-box method and the query method, is there a
preferred way of doing this?