Just a quick ?

[vpmedia]

I made the database and working on the forms and reports, but I am having a problem... Here goes I have a table where I scan products in to the database and here is where the problem lies, I am trying to scan the barcode to a person that I have set-up in the database. I scan it under him and I cant get it to take it out of the inventory and put it under him... It just stays in both places... Any help would be great what am I doing wrong... Not really good at programming..

[vpmedia]

Re: Just a quick ?

I guess there is no way to do this is there... or am I not explaining it right or what I am trying to do...

[Al Buchholz]

Re: Just a quick ?

I guess there is no way to do this is there... or am I not explaining it right or what I am trying to do...

Sorry - way too many questions after reading this.... While it makes sense to you, I'm not following it..

[Mike Wilson]

Re: Just a quick ?

Sorry,
I can't make heads-or-tails out of it either.

[vpmedia]

Re: Just a quick ?

lets make it simple... [A check-in and a Check-out]

1. You check-in the inventory to the database.

2. Then you select a person and scan the product out to that person

3. So it moves it from the databases inventory and puts the product on the persons personal inventory

4. If returned, then the product is rescaned back in to the databases inventory

[Tom Cone Jr]

Re: Just a quick ?

Patrick, I believe this can be done but it's difficult to offer specific advice because of a dearth of details about your setup.

Here's an example of how I might explain something similar to what you seem to be facing:

a) use a table to track the records currently assigned (checked out to) each person.
b) when assigning a product to a person require the user to click a "save" button to commit the transaction
c) the save button would run a script that would search what you are calling the "databases inventory" for the product_id
d) when the correct inventory record is found the same script would reduce the on hand count by one

The process would be reversed when a product is returned to "databases inventory".

What's not clear from your posts is how you've arranged the data. what tables are being used? for what purposes? Can one person have more than one of any product?

I should think you'd have at least 3 tables:
a) persons - containing contact information
b) assigned - containing a separate record for each product assigned to a person
c) unassigned - containing a separate record for each product in stock but not yet assigned.

A more efficient system is possible with only two tables, but until you tell us how you are doing it we can't really offer specific assistance.

There are simply too many different ways to interpret "I am trying to scan the barcode to a person that I have set-up in the database". You know exactly what this means. But you haven't told us yet.

[vpmedia]

Re: Just a quick ?

Ok I am sorry,
The inventory is Cable boxes, Modems, etc.

I am a contractor for Comcast

I need away to track the inventory Comcast gives to me and what I give to the techs.

Yes they can have more than one I will be useing barcode as the Item ID.

SO a check-in from Comcast
A Check-out to the tech
If not used by tech then check back in.

[Tom Cone Jr]

Re: Just a quick ?

Ok, Patrick.

do you have sample tables we can work with? if so, and the data is not confidential, can you zip them together and upload them here as an attachment to a reply? Use the Go Advanced button to get to the "Manage Attachments" dialog of the message board.

[Tim Kiebert]

Re: Just a quick ?

lets make it simple... [A check-in and a Check-out]

1. You check-in the inventory to the database.

2. Then you select a person and scan the product out to that person

3. So it moves it from the databases inventory and puts the product on the persons personal inventory

4. If returned, then the product is rescaned back in to the databases inventory

You can also take a slightly different approach. No need to be moving inventory records between tables. A piece of equipment can only be in one place at a time. So it is either in or it is out, and only one tech can have it signed out.


Add two fields to the inventory table; a logical that gets set to true when signed out and to false when signed in; and a field to hold the id of the technician that signed it out. when the item is returned the id in this field would be removed. When scanning an item out you would search the inventory table for the item and set the two fields appropriately.

You could add a history table that recorded the activity. This table would have fields for item id, technician id, in/out, and date/time. the record for the history table would be created every time an item was scanned in or out.

To see which items a tech has out would use a set based on technicians 1-many to inventory. To see the details of the technician who has a particular part you would use a set based on inventory 1-1 to technician.

[Tom Cone Jr]

Re: Just a quick ?

Hello, Tim. Yes, there are lot of possibilities, including the chance that products checked out to a tech will be installed for a customer, and removed from inventory altogether.

[Tim Kiebert]

Re: Just a quick ?

Hi Tom, Agreed. And also when returning to Comcast may cause the item to be removed from inventory.

Just checked the weather in your area. Looks like a nice afternoon for a game of golf. :)

[Tom Cone Jr]

Re: Just a quick ?

Yes, we had a small cold front blow through yesterday, is now cool, dry and crisp. But no golf for me today. I have an appointment with a roasted turkey !

-- tom

[Al Buchholz]

Re: Just a quick ?

Yes, we had a small cold front blow through yesterday, is now cool, dry and crisp. But no golf for me today. I have an appointment with a roasted turkey !

-- tom

We're pushing the snow out of the way or golfing with an orange ball... Those darn white ones hide in the snow... Yes even in the woods along the course....

Happy Tday..

[robert]

Re: Just a quick ?

No snow here in southern Ohio. Doesn't really matter to my golf game. Shot 88 on Tuesday but could have been better. Does this sound familiar?

Whatever happened to the originator of this thread?

[vpmedia]

Re: Just a quick ?

I have uploaded the file.... Like I said I am new to this...