Hello,

I would like to be able to have a form with a search feature which can draw from multiple fields on another form.

FORM A would be for all the data entry of the records.

FORM B would require the search feature, and would be to record usage of the items recorded in FORM A.

Is this possible to do, and if so, how would it be done?

Thanks in advance!
(Im still very new to this whole database thing so I have not alot of ideas how this more complex stuff works)

Example:

FORM A ---

Song Title

Artist

Album

Publisher

Release Year

FORM B---

[Search from FORM A]

No of Copies: x

etc.