jasoneon9 Posted September 20, 2016 Share Posted September 20, 2016 Hi been stuck on this for days so im thinking it may not be achievable i have 2 forms 1 customers the other a buy form the customers also has a portal showing history of records from the buy form my problem is we get tired of switching to the customers layout to see peoples history what im looking for is a way to see history on the same layout same table i know i can see other tables through a portal but cant figure it out that i can see history from the same layout / table very much appreciate on a pointer in the right direction please Link to comment Share on other sites More sharing options...
webko Posted September 20, 2016 Share Posted September 20, 2016 On the buy form, you must set the Customer ID - so you could make a portal between two Table Occurrences of the Buy table, based on Customer ID to Customer ID, so the portal shows the buy records for that customer.... Link to comment Share on other sites More sharing options...
jasoneon9 Posted September 20, 2016 Author Share Posted September 20, 2016 thank you think im getting somewhere but still not right i set the portal to customerid and voila it works but it just shows the one record thats currently displaying on left side of buy form twice on 2 rows when there should be 20 or so records Link to comment Share on other sites More sharing options...
webko Posted September 20, 2016 Share Posted September 20, 2016 Can you do: A screenshot of the portal in Layout mode? A screenshot of the relevant section of the Relationships screen in Define Databases? Link to comment Share on other sites More sharing options...
jasoneon9 Posted September 21, 2016 Author Share Posted September 21, 2016 Thanks for the help i have screenshots privately as its a working database and customers might not be to impressed if i accidentally post some data hope thats ok Link to comment Share on other sites More sharing options...
webko Posted September 21, 2016 Share Posted September 21, 2016 Replied Link to comment Share on other sites More sharing options...
jasoneon9 Posted September 21, 2016 Author Share Posted September 21, 2016 (edited) Thanks for the help it shouldn't be this hard why its easy to have a portal to related records well you cant get much more related than your self oh replied also Edited September 21, 2016 by jasoneon9 Link to comment Share on other sites More sharing options...
Lee Smith Posted September 21, 2016 Share Posted September 21, 2016 It’s NOT that hard provided we have enough information to understand what it is your need is. This was the reason I sent the link to Anatomy of a Good Topic in my Private Message. Reread these Steps, 7, 8 and 9, they spell out some of the information we are looking for from you. Lee Link to comment Share on other sites More sharing options...
webko Posted September 21, 2016 Share Posted September 21, 2016 I think I got enough back channel to help him with this, using a self-join in BuyBack on CustomerID Link to comment Share on other sites More sharing options...
jasoneon9 Posted September 21, 2016 Author Share Posted September 21, 2016 Thanks lee i did have a read and theres some good points to keep in mind thank you. Webko has been very helpful and im a gnat's whisker in completing my problem. I just think that in form mode there should be like a table tool like portal tool, only that you could table from its own layout/table, im sure it would make things much easier especially for us novices . Link to comment Share on other sites More sharing options...
jasoneon9 Posted September 26, 2016 Author Share Posted September 26, 2016 works great when you see it running ok makes me wonder why couldn't i see it youve made look so easy thankyou very much Webko really appreciate it thankyou Kind regards jason Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2896 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 accountSign in
Already have an account? Sign in here.
Sign In Now