October 9, 20169 yr 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, 20169 yr by Dr.Gopala krishnam raju AMBATI
October 9, 20169 yr Each entry in the prescription table should be a separate record. drugsMod.fmp12 Edited October 9, 20169 yr by doughemi
October 9, 20169 yr 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.
October 9, 20169 yr Same issue once again about normalized data and understanding and building a properly structured database.
October 9, 20169 yr Author 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
October 9, 20169 yr A normalized design with some scripting looks more like this. See attached file. . drugsModBFR.fmp12 Edited October 9, 20169 yr by BruceR
October 9, 20169 yr Author love ur mod sir amazing hope one day i will script and relate like u Learning alot from ur example Edited October 10, 20169 yr by Dr.Gopala krishnam raju AMBATI
October 10, 20169 yr Author 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
October 10, 20169 yr Everybody here knows the next 100 questions. Hire a developer. Edited October 10, 20169 yr by BruceR
October 10, 20169 yr 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.
October 10, 20169 yr Author 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, 20169 yr by Dr.Gopala krishnam raju AMBATI
October 10, 20169 yr 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.
Create an account or sign in to comment