All this can be done by opening the tables in design mode.
There you change the field names, etc.
In order to make a field a lookup, change the Display Control on the Lookup
Tab at the bottom to ComboBox and Change the RowSource Property by using the
Query Builder - Click just to the right of the Rowsource Property and a
button will appear.
KEEP IN MIND: If you go changing you field names, all of the Forms, Queries
and Reports built into the template will also have to be changed - Otherwise
you will start getting errors and will be prompted each time you try to open
a form, query or report that is looking for the old field name. So...All the
Textboxes (or ComboBoxes,etc.) will have to be re-linked to the newly named
field.
OTHER OPTION: leave the old fields there! Set their Visible Property to No
(in the Forms and Reports) and just Add the new field to the table (first)
and then Add them to ALL of the Forms, Queries and Reports (that they should
appear) as well.
jmonty
isons via AccessMonster.com said:
Hi jmonty,
Many thanks for your reply.
I have downloaded this template and found very useful. I want following:
1- I want to change the name of field ProductID to PRODUCT_NO to the
products table as I get
raw data from a source and want to use that data in my database. Fields
will be PRODUCT_NO,
PRO_DESCRI, RATE, PACK_QTY etc
2- ProductID field is autonumber whereas I want to change it to TEXT
3- I also want to set Product_No as lookup field in ORDERS DETAILS Table. In
my data entry form I
have to enter Product_No only and its corresponding product description
automatically fill in
from Products table.
Please help.
Best regards,
isons
Check out and download one of the template databases on the Office Online
website such as this one:
http://office.microsoft.com/en-gb/templates/TC010185481033.aspx?CategoryID=CT011366681033
jmonty
[quoted text clipped - 5 lines]
