Now I'm making an application like below.

1. formEntryAllUser

      =>Name,Email,Address ...etc basic infomation

2. formEntryLimitedUser

      =>Lookup to form1,some additional info

3. formEntryInfoOfLimitedUsers

      =>Lookup to form2,additional info necessary only for limited users

Now I've finished creating these forms and reports.

I want to use basic information in form 1 like name, email etc  in both form and report 3.

But in form 3 (there is only lookup to form 2) , I cannot get information from form 1.

To pass info from form 1 to form 3, do I need to add info in form 2?

I don't want to add unnecessary info in form 2... (form 2 has a nice way to refer to form 1 information both form and report )

I really want to eliminate redundancy as much as possible.

Is there any way to solve this kind of problem?

Thanks

Tadashi