FMMoron Posted February 10, 2005 Share Posted February 10, 2005 I currently have a 5.5 file that tracks customers and what they bought. It has worked for a while but my business has outgrown the functionality I built into it. I recently picked up a copy of version 7 and would like to build it the right way this time. Here's what I have currently. In the file I have 3 Tables. One for the customers, One for the orders, and one for the detail of each order. My reasoning for doing this is because of repeat business. I'd like to be able to easily see all of that persons orders. Ultimately, I'd like to display all of this information on one layout. I set it up to display 2 different portals. The main layout is the customer info, and the 2 portals are the order info, and the order detail. My first problem is that I can't seem to get the order detail to display unless I go to a different layout and put the data in. Then it shows up on my layout. The second problem is that I would like the portal which shows the "order detail" to only display the information from the record I select in the "orders" portal. Have I completely confused you yet?? This is just a taste of how I feel. I've attached an example of the file. I'm just taking a shot that someone is nice enough to take a minute to look at this and give me some guidance. Thanks for any and all help. Bob CustomerFile.zip Link to comment Share on other sites More sharing options...
This topic is 6618 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