You might want to start by looking at how a very experienced developer (Allen Browne) suggests this should be set up www.allenbrowne.com/AppInventory.html.
You should also consider a naming convention that doesn't allow reserved words and spaces in field names.
Duane Hookom MVP
MS Access
________________________________
> From: beebear@bex.net
> To: AccessDevelopers@yahoogroups.com
> Date: Tue, 28 Jan 2014 19:32:46 -0500
> Subject: [AccessDevelopers] New User - help with inventory program
>
>
>
> Hello
> I'm using Access 2003
>
> I am working on a project to track parts used in our shop. I have
> a table with all the parts and associated info about each part.
> I also have a table for the 10 machines in our shop and a table for the
> 12 techs names.
> I have created a database called inventory and have added these tables in it.
> I have also created a table called Usage that will track parts used on
> each machine based on the field entries below
> date
> machine
> tech
> partno
> location of the part
> quantity used
> quantity left in the bin
> amount the computer shows
>
> When I enter the part number, I would like the location to
> automatically be filled in from the parts table parts table
>
> Basically I'm looking to create a full blown inventory database to
> track parts in, parts out, parts out for repair
> parts used on each machine and this is just scratching the surface.
> Other than purchasing a database can anyone
> help out?
>
> Thanks
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar