Recent content by garnf1
-
G
Creating primary key values from field values?
Hello Colin & Aje, Yes its used for visual ID on prints & verbally etc... I could do as you suggest Colin, but I would still want it to be automatically created on job entry, and used thereafter for people to lookup in tables etc. so it might as well be put straight in as the primary key. I... -
G
How can I use a Form button or tab into a field to browse a table & select
I want to be able to compile a table of music titles with all their descriptor fields from a library of titles using a form. I hope that for each record the user will be able to go and browse the whole library (even clicking out on hyperlinks in that table to research several titles) and when... -
G
Creating primary key values from field values?
Reply - why I need it Hello Colin & Aje, It's to fit in with a system of codes that have already been used visually (by people) for some time on documents etc. to identify jobs & services. So when people enter new jobs (orders) they no longer have to work out and enter the keys themselves, but... -
G
Creating primary key values from field values?
Thanks & Eureka I used a Macro & SetValue to add the three fields from the various fields on other forms, on entry to the Key value I wanted calculating. I think my question was probably rather low level for everyone out there, but any tips are helpful, thanks. -
G
Creating primary key values from field values?
Just starting out: I enter new Jobs (orders for services) which have various sub-jobs attached. I want to build the primary key value for each subjob from several codes taken from other tables. e.g if a customer called Eric wants manualNo 12 in Chinese the key for the job would be ER12C. Any...