Dear friends.
I am new in access databases and i want to learn somethings from forums. I want to create a database for a service computer. So i need some help
Device Table
--------------------
CodeDevice
PelID
DevDescript
Manufacture
DevSerial
DevModel
DevPart
Customers Table
-----------------
Code
PelID
Company
AFM
Tel1
Tel2
Mobile
Address_1
Business
Memo
fax
So i want to create the above tables. I am not sure what have to be the common field and what willl be the relationship between the common fields. For example i have PelId as common. So do i have to connect that 2? and do i have to put a key on that 2?
Thank you