Aztra

Thanks fseiple, I greatly appreciate your comments and suggestions . Presently my work order types are in a related field and the prefix is carried over to the type row in the workorder table. It actually sounds like your explaining my access setup in you final coments, so it’s an fm script I need to run. I’m trying to follow what your saying, I’m a bit confused on how it gets the next highest number, or better yet where. I’ve attached a portion of the main table converted from Access so you can see the end result. PO_numbers.fp7.zip

Hi, guys I need some help converting a work order data base from Access to FM. Our work order numbers are department specific. Electrical as an example would use E0001…. Where plumbing would use P0001… In Access my table used 3 fields to accomplish this. 1- Type – This is a stored value from a look up table, this is a letter that defines the type of work order . E= Electrical, P= Plumbing, C= Controls… 2- WOSeqNum – This field keeps track of previously used numbers. 3- WoNum- this is the combined number IE .. E0001 I would like to point out that I require sequential numbering. Each division uses the same numbers IE. Electrical will be E0001,E0002, as will Controls be C0001, C0002… The code I used to accomplish this in Access was. WOSeqNum = Nz(DMax("WOSeqNum", "TblPO_numbers", "Type = '" & Me.Type & "'"), 0) + 1
WoNum = [Type] & "" & [WOSeqNum] Can FM do this with it’s functions? Anyone have any ideas to help me with this issue? Any help would be appreciated. Todd

Thanks Bruce.. I figured out my error..

Basic question from a Nube. I have a simple PO system set up, only 3 tables. I have PO, customers and locations. On the PO form ( the main one) after I chose a customer I want to select the location from a list of locations that have a relationship to the customer selected. To do this I used a Pop up menu and set it up to pull data from the locations table. The issue is when I call up the table it only shows one location. If I save it, close it then open it up again all the locations will show up in the list. Since Im new to FM I not sure how to have this data refresh without have to close the data base. In Access I would just use a simple Requery command.