Simple database

[qwfx]

hi crew i am super newbie:
I just have 2 tables 0ne table with
a)3 fields, bodypart(autonum), partname(text), Code(#),Code2(#)
b) 3 fields Lname, fname, date, code

What I want to achieve is lets say a client comes, and I type bodypart 10, how can the partname and Code show automatically,
and save that info so that when client comes later I know what code I used,
and how can all this be showed in a gui interface as opposed to a table form view,
thank you
regards,
qw

 

[pl456]

I think you need to do some googling or search access help files.

Look for queries and and how they work, for you to search the tables of data you will need them.
When you have created a query you can then create a form that is based upon one of your queries, this will display the result in a more familar style that you see with pretty much all databases.
Also look for parameter queries which allow you to enter the query criteria without having to open/design the query.

I would also look at relationships, understanding how your tables link together is pretty important.