Sari Posted January 23, 2005 Share Posted January 23, 2005 I've attached my latest (! version millionth) relationship diagram because I just don't seem to be able to get my head around the problems I seem to be having: 1. I want to run a status report based on all live jobs. I have a portal within the report to show all tasks allocated to employee within each job number. I can get my report to show the first task but it won't show any of the others. 2. I want to build Purchase orders based for job numbers. The Supplier will have a Company name related to the Company Code in the Company table and the location in the Company location table. So far, I can enter the Company Code and get the correct Company Name. But when I try to enter the company location based on a value list with conditional values, I get another companies details. I've got to do the quotes and invoices yet but I can't seem to get past these 2 problem. I didn't have any trouble in Access.... TattooRelationship2301.pdf Link to comment Share on other sites More sharing options...
This topic is 6639 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now