Need help developing forms

[TheTubaGeek]

First time poster, so please be nice. The search has not really played nice with me.

I have created a database in Access 2007 for an Inventory Tracking system. The idea is to maintain our in-house inventory of PCs while tracking when PCs are shipped out to locations and received from the manufacturer or from the locations we ship to.

I have created 5 tables:

Inventory
INV_PK
ServiceTag
AssetNumber
Model_FK
InOut (Boolean)
Notes

Model
Model_PK
Model

Techs
Tech_PK
TechName

PC_IN
PCIn_PK
ServiceTag
Model_FK
Recvd_Date
Tech_FK
IncidentNumber
PC_Replaces
Swap (Boolean)

PC_Out
PCOut_PK
Inventory_FK
Model_FK
ImageDate
ImageFor
PCName
IncidentNumber
ImageBy
2xCheckDate
2xCheckBy
ShipDate
TrackingNumber
Recvd_Date

I need to create 2 forms for PC Out and PC In, but keep running into JOIN errors. I'd appreciate any input anyone can provide and can, upon request, attach the database here.

 

[bob fitz]

Hi TheTubaGeek

but keep running into JOIN errors

What exactly have you been trying to join and what errors occur?

 

[TheTubaGeek]

I think I found out what I was doing wrong. I've concentrated my efforts on the PC Out form and will hopefully have that one to a point where I can come back and look into this issue.