Pretty much have scrapped that idea, couldn't get it to work, that would tie my user down to one id per location. This is what i am left with...
select `WorkID`,
`User Name`, Auto Entered when they click add
`Priority`, drop down from controls table (works great)
`Created Date`, Defaulted to Read Only with Now()
`Item Type`, Drop Down Controls Table ( Works Great)
`Barcode`,Drop Down that is dependant on the LocName. Pulls a list of assets from my srms table that match the locname entry from locations table. (Works)
`Multiple Barcodes`,Hand key multiple barcodes
`LocName`, Dropdown from Locations Table, Stored as Char(3), used to drive system. Will successfully pull the location name and place the correct id number in table. Use of this fields allows my users to select there location and it would pull the tech for that site automatically - which doesn't work.
`Room`, Drop down that uses the LocName to match up wtih the srms table and get the room list for that location (works great)
`Contact Phone`Type in a contact number
`Closed`,Admin usage
`Status`,Admin Usage
`Assigned To`,This should be pulled from the locations table after the LocName is selected, doesn't work in live mode only in ASPRUNNERPRO Build mode. Doesn't work and driving me insane <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=5984&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
`Problem Description`, tech usage
From work_order
- -- - - - -
select `LOCATION`, char(3)
`STNAM`, Name of Location
`Assigned To` Technician
From `locations`
