DougP
1. Can you have a loopup table as one of the fields.
So a user could pick from multiple opions.
Like Location would have a drop down box that they could pick Front, Back, East, etc. etc. ??
Answer: yes........ The application I have in production presently uses an Operator table, a Business Location Table, a Sub-location table, an Inventory table.
The user has to select his/her operator id from a table, has to select the business location that they are in after which the application shows them a list of sub-locations that are in that business location which they can either select manually or scan a label that has the encoded sub-location in it (i verify the sub location is correct for that business loc). All the location related information is maintained in an access2000 application which allows the users to set up business locations(could be stores etc but in our case are Farm and Store locations) and sub-locations within the business loc's. The locations all have a location "ID" and location Name (so the users don't get confused).
After the user selects a valid sub-location, they have to tell the system what sort of count they are doing. In our case, they either do a "partial" count of a sub-location or do "adjustments". For a Partial count, they have to count all "like" items in the location, for adjustments, they can add receipts/delete items, enter dead / damaged product, upgrade / downgrade (we grow plants so some die, are ready for sale or need more time to root in fill out or be upgraded to a larger container etc etc) etc etc.
For a physical count or cycle count, the user establishes the location(S) they want cycle counted or physical counted in the access application, the satellite forms application on the handheld knows what locs are scheduled for cycle or phy counting and the code behaves accordingly when the date the count type is reached.
2. You are using Access to send data to it right?
How does this work, you dock it, and the Palm desktop software uploads a file ???
Or??
Yes, plop the unit in the docking station, fire up the access application, tell the access app what you want to do (upload/download etc etc), hit the hot sync button on the handheld and viola, the access app tells the handheld what tables it wants uploaded (or, alternatively, what tables to download (all depends on what the user tells the access application to do). Also, i have a symbol cradle with the built in modem so the users can dial up the pc with the access application on it and hotsync from remote locations. (we are using the spt1700 batch version but i intend to try out a 1740 wireless version soon just for fun).
in any event, satellite forms is all tied in with access directly, i even show the user the results of the hotsync uploads and give them the option to accept or reject the data...... a preview of sorts....
DougP, MCP