saving to different table

the two tables are dplayer and dteamsetup. the fields in the player are the regular address information(name, address, phone,etc). the fields in teamsetup are team number, team name and player1 - player4.there are going; to be many teams. i have the relationshhip set up between the player fields and the name fields.  i have the object inspector set the way you said. i save to dteamsetup. i get the error "there is no column dplayer in dteamsetup". it probably would work if i didnt try to save the team number and name but that is what i do my search on. i hope this was able to make it a little more clear what i am trying to do. thanks again for your help

Morning LHimes,
As I understand your posts, the relationship needs to be created in the dteamsetup table pointing to the dplayer table.  The error message you are getting sounds as if you have it set up in the other direction.
However, if you have 4 players in each team and you want to select each player from the combobox, you will, in effect, need to create 4 relationships (one for each player selected).  Whilst that is possible, it gives you a problem in any tablegrids, in so far as the extra 3 relationships will be displayed by their record-id's and not the actual player names.  To get the actual player names, you will have to use calculated fields to pull in the descriptions.
I've knocked up a little example that I hope clarifies the above and highlights the problem.
I think it would be more usual to have a 3rd table (dteamplayer) to hold the details of each player in each team with a relationship between dteamplayer and dteamsetup to avoid the repeated relationships problem described above, but you may have specific reasons for not wanting to do it this way.
Hope this helps,
Derek.

unfortunately my version was too old to run that sample. i have the relationships set up as you said. i am enclosing my project, which is quite large and just getting started, so you can better see what i am trying to do. the forms i am currently talking about are ViewTeam and TeamSetup. the tables; are dplayer and dteamset. hope this helps

lee

deleted that file. still get the error "table dteamsset has no column nammed dplayer" when i try to save. steps to run are: add my name only to address, go to team set up, put number 1 in team number, any name in team name and pick my name for player 1. then save. then i get above error.

lee

well, i had to download the new version before i could look at it. i was hoping to get by on my free version until i could see if this was going to work out for me. yours worked fine. i tried to copy any chnges to mine but still no luck there. guess i will have to use our version. i do need the names to show up instead of the id in the grid tho. how do i go about fixing that. man, this sure would have come a lot easier 50 years ago.

lee

new version of mvd looks good. the new file you sent works fine also. i realy do appreciate all of the time and effort you put into helping me. i ope i can get pretty far without any more help but i anticipate i will probably need some when i get to printing out the reports. i did notice there used to be a filter in search that would allow you search on one character.  that does not seem to be available any more. is there a work a round or fix for that. once again, thank you for your help

lee

sorry, i lost myself for a bit there.  the filter is in the properties for a textbox. set to s% allow to search on first character. before i get any more vested in this project i need to find out how much i can do. a year in 8 ball consists of 2 seasons, each 2x weeks long. a players handicap is based on the average of the weekly score of each past 2 seasons plus all of the weeks of the current season. as he finishes the current season one past seasons scores drop off. am i going to be able to do that with this. on the scoresheet, the scores are manually put in. i found a script in the general forum to add the totals on the form but it doesnt seem to work. i dont get any errors, it just doesnt do anything.sorry for alll the questions and problems.

lee

I agree with Derek. I don't see anything popping out which would prevent you from completing your project. For your "s%" search, you may need to use SQL QUERY action to do that. I saw in your project where you defined totals, but I didn't see where you actually put in the calculations.

I have found that Delphi Basics (http://www.delphibasics.co.uk/) is a good resource. You will also need to understand all the possible events which exist on all form objects in MVD. These events are where you will be placing your scripts. It looks like you will have a lot of calculations in your project. So for a simple form example, to add two numbers on your form and display the result on your form, a script could be as simple as

Form1.edit1.value := Form1.edit2.value + Form1.edit3.value;

You would typically place this script on your fields OnChange event. When you double click into an empty event in the Object Inspector Events tab, MVD will automatically put in the Procedure, Begin and End statements in the Script file for that particular event. You just place your code between the Begin and End statements.

You'll probably want to understand how to construct "If" statements for conditional processing and "ShowMessage" and "MessageDlg" for interacting with the user. Understanding basic SQL can help in certain situations. Since it looks like you will be totaling groups of records for averaging, you'll probably want to know how to do "SqlExecute('Select Total(Amt) from YourTable where....');"

I have only been around this product for about 5 months, including the 60 day trial. So I am by far not an expert, but I have been able to complete a fairly sophisticated project in that timeframe. Once you see how certain things work it becomes easy to repeat it for other situations. Of course, if you get stuck, you can always come back to this forum for specific problems or how to's. I am always amazed as to the help that is dedicated to it as you saw from Derek. Dimitry is the master. If it can be done, he'll have a solution. Hope this all helps. Good luck with your project.