Add item to TABLE and reflect it in canned reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I downloaded a template for household inventory. I want to add another
FIELD called Beneficiaries. I went under TABLES and added it, which created
Beneficiary ID and Beneficiary Name. When I go under FORMS or REPORTS I try
to add the field for Beneficiary, but it never gives me the option to choose
Beneficiary under the SOURCE (it's not listed). I've tried using the wizard,
copying other reports and editing them, etc. to no avail. Please help.
 
I downloaded a template for household inventory. I want to add another
FIELD called Beneficiaries. I went under TABLES and added it, which created
Beneficiary ID and Beneficiary Name. When I go under FORMS or REPORTS I try
to add the field for Beneficiary, but it never gives me the option to choose
Beneficiary under the SOURCE (it's not listed). I've tried using the wizard,
copying other reports and editing them, etc. to no avail. Please help.
Click to expand...

Are these fields in an existing table? Or a new table.
If existing table...
The record source for the report is probably a query or SQL
expression.
Click on the Report's record source property line, then click on the
button with 3 dots that appears on that line.
Add the new fields to the query grid.
Save the changes.
The new field will now be available in the Field List tool button.
Drag it onto the report.

If a new table...
Do the above up to opening the query.
Add the new table to the query.
Make sure there is a correct relationship established between the
tables.
Add the new field to the query grid.
Then continue as above.
 
Back
Top