Good afternoon!!
I would like someone to validate what I have done. Here is it:

I am working in an existing database. I have a particular table, let's
call it [POTRL] which captures infomation pertaining to purcahse orders
issued by our company. I am not permitted to edit this table in any
way, because it is part of a VBA software application.

I need to capture some additional information - so what I did was
create a new table called [POCUST] (I checked with the vendor of the
software package, and this is acceptable) into which I will enter data
in the new fields. What I did was created the new table, with a
primary key field matching that to the [POTRL] table. I have to
somehow dump in the data from [POTRL] table into [POCUST], so that I
can establish a relationship between the two tables, build a query and
finally construct a form for data entry.

The way I dumped in the data into [POCUST] is via unmatched query, then
an append query which populates [POCUST] with all the data I want from
[POTRL]. So essentially what I have is a new table with all the data
from the "untouchable" table, plus a few extra custom fields that I
have created. Everything works fine!

I built the query, and the form for data entry. In the form's OnOpen
event, I run the macro which populates the [POCUST] table - so when the
form loads, I have the most updated information to begin data entry.

I can finally make additional data entries to populate these newly
created fields.

This is the first time I ever had to do something like this. Does my
logic make sense?? Is there another way to ahive the same result??

"Junior" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Good afternoon!!
> I would like someone to validate what I have done. Here is it:

The reason for doing it should be validated first. If you are doing the
wrong thing for the wrong reason, then there isn't much point to validating
the steps you took to do it.

--
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com