Template needed for database w/single input form

[Sonny Jim]

My client wants to have a single input form to input data into several different tables. All of this feeds reports that combine the data entered from the single form in different ways.

I need to be able to see all the data on this form, search any field using the Find/Replace button, use a drop down box to be able to choose values that may have already been entered into a given table, and enter in new values not currently in a given table.

Can anyone direct me to an example of something like this that I might use as a guide?

 

[missinglinq]

Unless you also go by the name of Xeseus on TEk-Tip you might moitor this thread over there!

http://www.tek-tips.com/viewthread.cfm?qid=1330154&page=1

 

[Sonny Jim]

Thanks missinglinq, but that is me.

 

[missinglinq]

Thought the post was too similar, but you never know!