Dr.Gopala krishnam raju AMBATI Posted October 9, 2016 Share Posted October 9, 2016 (edited) i made 2 tables one is drug where there is information of respective drug other is prescribing table and made following relationship i made drug field in prescription table as value from drug name of drugs but when i am selecting drug select in prescription table all fields are becoming same medicne instead i want to it to be different please someone help me drugs.fmp12 Edited October 9, 2016 by Dr.Gopala krishnam raju AMBATI Link to comment Share on other sites More sharing options...
doughemi Posted October 9, 2016 Share Posted October 9, 2016 (edited) Each entry in the prescription table should be a separate record. drugsMod.fmp12 Edited October 9, 2016 by doughemi Link to comment Share on other sites More sharing options...
Dr.Gopala krishnam raju AMBATI Posted October 9, 2016 Author Share Posted October 9, 2016 u shifted to list view i want it to be changed in form view Link to comment Share on other sites More sharing options...
doughemi Posted October 9, 2016 Share Posted October 9, 2016 Each prescription must be in its own record. In order to show multiple records, the layout must be in list view. The way you attempted to do it, you are simply repeating the same related record over and over. Link to comment Share on other sites More sharing options...
bruceR Posted October 9, 2016 Share Posted October 9, 2016 Same issue once again about normalized data and understanding and building a properly structured database. Link to comment Share on other sites More sharing options...
Dr.Gopala krishnam raju AMBATI Posted October 9, 2016 Author Share Posted October 9, 2016 1 hour ago, doughemi said: The way you attempted to do it, you are simply repeating the same related record over and over. i dont want this to happen thats y asking help Link to comment Share on other sites More sharing options...
bruceR Posted October 9, 2016 Share Posted October 9, 2016 (edited) A normalized design with some scripting looks more like this. See attached file. . drugsModBFR.fmp12 Edited October 9, 2016 by BruceR 1 Link to comment Share on other sites More sharing options...
Dr.Gopala krishnam raju AMBATI Posted October 9, 2016 Author Share Posted October 9, 2016 (edited) love ur mod sir amazing hope one day i will script and relate like u Learning alot from ur example Edited October 10, 2016 by Dr.Gopala krishnam raju AMBATI Link to comment Share on other sites More sharing options...
Dr.Gopala krishnam raju AMBATI Posted October 10, 2016 Author Share Posted October 10, 2016 Sir medications are jumping from one portal on right to left into left instead i need to add in left portal but values should come from drugs is it possible in left portal only drug name is editable others are not ?? drugsmodgkr.fmp12 Link to comment Share on other sites More sharing options...
bruceR Posted October 10, 2016 Share Posted October 10, 2016 (edited) Everybody here knows the next 100 questions. Hire a developer. Edited October 10, 2016 by BruceR 1 Link to comment Share on other sites More sharing options...
Dr.Gopala krishnam raju AMBATI Posted October 10, 2016 Author Share Posted October 10, 2016 (edited) sir please Edited October 10, 2016 by Dr.Gopala krishnam raju AMBATI Link to comment Share on other sites More sharing options...
Wim Decorte Posted October 10, 2016 Share Posted October 10, 2016 What Bruce is saying: we're here to help with specific questions where you are stuck on, but you can't lean on this community to actually build things for you, for free. At the very least - in addition to describing the problem - you need to indicate the various things you have tried and where it fails. That way we can help your learning, not build the actual thing for you. Link to comment Share on other sites More sharing options...
Dr.Gopala krishnam raju AMBATI Posted October 10, 2016 Author Share Posted October 10, 2016 (edited) 19 hours ago, Wim Decorte said: What Bruce is saying: we're here to help with specific questions where you are stuck on, but you can't lean on this community to actually build things for you, for free. At the very least - in addition to describing the problem - you need to indicate the various things you have tried and where it fails. That way we can help your learning, not build the actual thing for you. Edited October 11, 2016 by Dr.Gopala krishnam raju AMBATI Link to comment Share on other sites More sharing options...
bruceR Posted October 10, 2016 Share Posted October 10, 2016 Wim: correct. There are a LOT of things that need to be changed in these files and a lot of support and training required; combined with some fairly extreme resistance about learning. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2752 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