Report versus Form

[Sharon Bracken]

The Report Editor has the capability to import a Form, Browse, Report, Label, or Letter.

Does the Form Editor have the capability to import a Report?

We would like a particular report mirrored to a form for data enry. The form appears to only filter from the parent to the child. It is like the great, great grandchild that we would like to include in the filter. If we could import a report into a form, it would be duplicated in detail. Is this possible?

[Tom Cone Jr]

RE: Report versus Form

Sharon,

No, I don't think you can import the report layout and expect it to behave the same way on the form as it does in the report. The report engine displays fields from multiple detail records with only a single instance of the field object in the details band (region). There is no equivalent 'band' in a form layout.

Tell us more about what you need. Perhaps others will be able to offer other ideas for you.

-- tom

[Sharon Bracken]

RE: Report versus Form

Thanks Tom,

What I am really trying to do is have a form function similarly to a report - but be capable of accepting data entry. We have a student database with child and grandchildren etc.records. We need the form to display multiple records for individual students determined (filtered?) by their occupational choice. Example: student "A" has selected a training program, an occupation within the program, courses within the occupation, and specific skills within each of the courses. we need those specific skills to appear on a form, based on the students choices. Our attempts so far have produced multiple student skills or multiple students not just the individual student in question matched to his skills.

Our database is constructed as follows:

Parent - linked on student Id + program ID

Child - linked on student Id + Program Id + occupation Id

GChild - linked on program Id + Occupation Id + Skill Id

GGchild - student Id+ Program Id + Skills Id

We want to generate records in a form filtered to the student Id, program Id and Skills Id for each individual.

How can we make this work????

Sharon
















Sharon

[Sharon Bracken]

RE: Report versus Form

Thanks Tom,

What I am really trying to do is have a form function similarly to a report - but be capable of accepting data entry. We have a student database with child and grandchildren etc.records. We need the form to display multiple records for individual students determined (filtered?) by their occupational choice. Example: student "A" has selected a training program, an occupation within the program, courses within the occupation, and specific skills within each of the courses. we need those specific skills to appear on a form, based on the students choices. Our attempts so far have produced multiple student skills or multiple students not just the individual student in question matched to his skills.

Our database is constructed as follows:

Parent - linked on student Id + program ID

Child - linked on student Id + Program Id + occupation Id

GChild - linked on program Id + Occupation Id + Skill Id

GGchild - student Id+ Program Id + Skills Id

We want to generate records in a form filtered to the student Id, program Id and Skills Id for each individual.

How can we make this work????

Sharon
















Sharon

[Sharon Bracken]

RE: Report versus Form

Thanks Tom,

What I am really trying to do is have a form function similarly to a report - but be capable of accepting data entry. We have a student database with child and grandchildren etc.records. We need the form to display multiple records for individual students determined (filtered?) by their occupational choice. Example: student "A" has selected a training program, an occupation within the program, courses within the occupation, and specific skills within each of the courses. we need those specific skills to appear on a form, based on the students choices. Our attempts so far have produced multiple student skills or multiple students not just the individual student in question matched to his skills.

Our database is constructed as follows:

Parent - linked on student Id + program ID

Child - linked on student Id + Program Id + occupation Id

GChild - linked on program Id + Occupation Id + Skill Id

GGchild - student Id+ Program Id + Skills Id

We want to generate records in a form filtered to the student Id, program Id and Skills Id for each individual.

How can we make this work????

Sharon
















Sharon

[Tom Cone Jr]

RE: Report versus Form

Sharon, I think the compound link field expressions are getting in your way. Try this:

Child table use the student id field only
GChild table use the Occupation ID field only
GGChild table use the Skills ID field only

-- tom

[Tom Cone Jr]

RE: Report versus Form

Sharon,

Immediately after posting the previous I began to have second thoughts. Take the advice with a large ration of salt. Don't spend much time on it if results are positive immediately.

A better suggestion to you would have been to encourage you to post a working copy of the database here so that we can exactly what's going on.

-- tom