How can I change a field in Access 2007 template

P

pkovacevic

I am trying to use the Asset Tracking template and I need to change the
field: condition to S/N, so that we can input various serial numbers into
this. I need to know what all I need to change so that this DB will work
properly with all of the relationships, etc. Thanks in advance!

Regards,

Pete Kovacevic
 
M

Maurice

In the Navigation pane choose tables and related views. That way you can
check which objects use this field and where you can expect any problems. I
see some forms which use this field as a combobox. If you don't mind seeing
your S/N in a combobox than nothing changes. Maybe it might just be easier to
add an extra field S/N and go from there.

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
Need help modifying the Asset Tracking DB for Access 2007 0
Req: Access db relationship issue - should this table be 1-2-1 ? 6
Page numbering with Merged Document and IF statements 1
Design Help 4
Req: An Asset -> Fixture relationship problem: how to maintain 2 dependant tables. 1
Data Fields Changing 2
Lookup field and Relationships 2

Top