Inventory Database with ability to "check out" equipment to an individual

[ajh2014]

Oops on the lookup fields Steve... by data entry I just meant typing in all of my assets. Unless I can just copy and paste from the old master db which would be much simpler. Should I do that or wait until I build my forms?

[June7]

Copy/paste is possible. So is import with import/export wizard.

[ajh2014]

Hows this?

[ssanfu]

You have the Dept PK in both Customer table and AssetTracking table. You have possibility of having the customer in dept assigned to N00, but in AssetTracking the check in/out record for dept could be N4. Does that matter? I would have the DeptID_FK field in one or the other table, probably in AssetTracking. Do you need to track or does it matter the history of which dept a customer has been assigned?

What happened to the check in/out date & time fields in table AssetTracking?

As June said, importing is probably the easiest.
In the attached dB, I added an example form for editing/updating Assets.

[June7]

Why is DeptID_FK in both tblCustomers and tblAssetTracking? Possible circular reference http://www.codeproject.com/Articles/...atabase-Design

[ajh2014]

Ok that is starting to make more sense. I deleted the DeptID_FK field from the tblCustomers and left it on the tblAssetTracking. How did you go about making the form though? I've tried to make something that I wanted through trial and error and haven't received any positive results. Would using the form wizard be my best option? I think I accidently deleted the time fields when I was changing some stuff around but will add them in now. Thanks

[June7]

I don't use the design wizards. They do stuff I don't like, such as 'grouping' controls into 'layout' groups. But it is easy enough to eliminate them. Select all the controls and right click > Layout > Remove. Now can easier resize and move controls at will.

What is not positive about forms you built?

[ajh2014]

It seems that I always pick the wrong field and I'm not sure if I can mix and match fields from one table or the other. I would like to make a form that allows me to check assets out to customers.

[June7]

The Lending Library has good example of that.

A form normally can enter/edit data for one table. Why would you need to 'mix and match'?

[ajh2014]

I guess that is why the tblDept was included in the tblAssetTracking vice tblCustomer....

[ajh2014]

I really liked the layout and functionality of the lending library template but there was a lot of stuff I wanted to take out and or modify which would always stop the template from working properly.

[June7]

So use it as guide to build your own. Get familiar with the structure and code and adapt what is relevant.

[ssanfu]

I agree with June. The best way to learn is to reverse engineer a template. (lots of templates - I have )

I had a few minutes, so I added a couple of things to your dB to help you get you started. You still need to add data to the tables and create forms to add/edit the tables.

[ajh2014]

Wow Steve... Exactly what I need! Can you PM with some steps on how you accomplished this? I also need to have the asset serial number displayed in the Check_In_Out form but I'll try and figure that one out for myself.