Customer's Record ID

[whosbob]

Hello, We are a large Flea Market, Located in San Jose Ca., Our Monthy Vendors already have a ID Badge assigned them, (We have no problem reassigning new Seller Badge ID.) I'm thinking of using the RecordID as a unique never reused badge No. So now I need to search customers by Badge No. and playing around with dialogs I can easily insert a Badge No. Element and it appears I can change the actual function to possible insert the Record ID. into
a Read Only Badge No. element and then I would have the ablity to search by
Badge No. So the question is , do you have an example of what this expression element function might look like?

Thanks for any insight,
whosbob

[sspielbusch]

The Record ID is alreday shown on Customer Details, but isn't searchable. So what you really need is to add a custom field for a Badge ID. Adding a field and putting it on the Custoemr Details dialog is covered here:
http://campgroundmaster.com/news/add...othecusto.html

Any custom fields are automatically searchable using Find Customer, so that's covered.

However it sounds like your real question is how to get the record ID into that field automatically, so you don't have to enter it each time. For this I would recommend adding an Event Action, with the trigger "New reservation, after". Thre isnt' a trigger for new customer, but it's probably safe to assume that they don't really need a badge until they're actually renting a space anyway, so this should work fine.

The action to set the field would use the function SetFieldText(rRecord, cFieldName, cValue), e.g.:

SetFieldText(ThisCust(), "Cust_User_Badge_ID", FieldText(ThisCust(), "Field_Index"))

This would probably also put the "#" in the field, so if you don't want that then you can use the Mid() function to trim if off, eg:

SetFieldText(ThisCust(), "Cust_User_Badge_ID", Mid(FieldText(ThisCust(), "Field_Index"), 2))

[whosbob]

Thank You Stan! , This was exactly what I was hoping for, this will even work out better with the 'reservation after' trigger...I realized later that this should have been more on the technical board so, I have another question which I leave over there...Thanks again Stan for your support, well done program, so far so good....