I have a database that is held in 2 locations and data is entered in the same table. Following data entry the information is then exported as Excel, emailed and imported in a third location.

As this table is then related to a recipients table by a unique ID I have defined three field for ID purposes. The first is an auto enter number field, the second is an alpha field which gives a single letter determined by the user name and the third is supposed to be the ID field by combining the information from the two other fields. The problem I am having is that the ID field is just showing 0 when the Alpha field is showing I and the number field is showing 0006. I have defined the ID field as a text calculation field with the calculation GetAsText(Alpha) and GetAsText(Number)

AND is a logical operator(find for blonde hair AND blue eyes).

You need to use & to concatenate(join) text. "A"&"B"&"C"=ABC

As for the rest of your post I am afraid I

couldn't make head nor tail of it but if it is what I think it is then gathering and linking the data in that way sounds like a recipe for disaster if ever there was one.

Best of luck

Phil

Thanks, perhaps I will learn to think before writing. If you would explain why it would be a disaster to link the text that way I would appreciate it.