Hi There,
I'm creating a fairly straightforward database for a company that works mainly on exhibitions. They collect the customer's data and need to produce a sales receipt with an agreement. I'm looking for some advice on setting up the customer ID, order ID.
I'd like the customer ID to be constructed as follows, 6 digit date figure of when the record is created, then a two digit counter, then the event ID where the record is being created. E.g 260818/01/12. Date/Counter/EventID
I'd then like the sale order ID to be fashioned from this, ig Date/Counter/EventID/OrderID. This way over time staff would be able to know where to look for certain files or reference an Event ID sheet and instantly know who to speak to in the office etc.
I know creating calculated fields in ID fields can start getting messy so just looking for some advice on the best way of doing this.
Thanks Jake