I am not much of a programmer and I could use some help with this.
I am attempting to clean up a database. One of the things I would like to do is combine two tables – one contains “Internal” projects and the other contains “External” projects. They both have the exact fields and an identifier field that indicates “External” or “Internal”. The two tables were seperated because they needed sequential numbering. Currently the numbers are in an autonumber field in each table.
What I need help with is writing code for when new records are created in the combined table. Basically, I need code that looks at the ProjectType field(Internal or External) then locates the last ProjectNumber that was used in combination with that project type.
So you could have Internal project number 1 and External project number 1. The very end result of this is having it show as “IP01” or “EX01” to the end user as a concatented field on a form. (This part I know how to do).
Can this be done? I really would like to combine these tables and clean up a bunch of unnessary queries related to joining the records from the two tables.