display data from another table to another table

[Guest]

Sir, I have created two tables one is called categories and the other is
called vehicle list, in the categories table is a field called CategoryDesc
(Category Description), I want to be able to display a specific record from
under this field to be display in a specific field in Vehicles list, but I
dont know how to do this, I also dont want the user to be able to enter data
in this field, basically I want it to be read only. Can you please give me
some assistance as to how I can do this and does this have to go into the
Default Value box in the Vehicles List table?

I am so looking forward to hearing from you with your answer, best wishes

Mark Cock

 

[Arvin Meyer [MVP]]

You can display data from 2 related tables in a form/subform or by using a
query and linking on a common field (usually a PrimaryKey ForeignKey).
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Joseph Meehan]

This really depends on how your tables are normalized and constructed.
I don't think I can give you specific information without knowing more about
your tables.

I suggest you check out the following in the help file.

- Normalizing tables
- Linking tables
- User level Security:

Note read I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793 for
information on security.

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.