Databridge advice needed.

I am trying to create an update form to show competition results.
At the moment I do not know to achieve this, before I spend many hours learning how to - I thought it might be a good idea to find out if it actually possible with databridge.
I want to create a form that will allow me to select competitors from my database (competitors view) via a dropdown and update the selected records to the results (table).
I had a look at the dynamic dropdowns tutorial and it looks promising but I could not see a way of updating the results in the target to the results table.
I am slowly getting my head around php but it is a steep learning curve.
Thanks for any information.

How are the competitors and competition tables set up?


You could create what you describe using the Data Assist search wizard, but depending on the table set up, you may need to start with a join query on the results page.

you could create a recordset to return the competitors on the search page, use that to populate the select list that the Data Assist Search wizard creates.

Thanks for the reply, I think the easiest way to describe my database is for me to attach a relationships diagram.
I have been using this mySQL (website display purposes) database with an Access front end (for updating) for a while now and appreciate that I might have to modify it somewhat to enable it to be used.
Initially I would like to pick an event(trial) then select dogs and then update that data to the results table. Once I have got my head round that i can look into it further .
Is this something that I can use dataassist for.
Could you explain further what you meant by join query on the results page.

I am not asking for step by step instructions, a nudge in the right direction would be appreciated.
Many thanks,

Hi Mark

Sorry to interject in the thread, but was wondering what the software is that you've used in the screenshot to create the relationships?

Cheers

Jamie

Hi Jamie,
Its just a screen grab of the MS Access relationships window.
It can also be done with MS SQL and you can do the same thing with SQLyog for MySQL.
Look for the schema designer.
I don't know if it can be done with phpadmin as I don't use it.
Hope this helps.
Mark

Thanks Mark. Appreciate that.... just another thing to add to the list for me to investigate and learn! lol

atb

Jamie

A join query is a query that joins related tables together.

Since you used access for generating the screen shot, you should be able to use the access query builder to generate the join query for you.

when you select a trial, pass the trial ID to the results page.

the record set would need to join the TrialsT, TrialsCatalogT, TrialCompetitorsT, and DogsDetailsT and filter on the trialID passed in using the TrialsT.TrialID column.

using the join query will allow you to return the related information for the selected Trial from the DogsDetailsT table.

morte details on join queries can be found here:
sql_join_inner.asp

Hi Jason,
Thanks for getting back to me.
Sorry I worded my last reply badly, when using the dataassist wizard it works on a single table or view, I cant find any way to use a recordset. Am I missing something or are you taking about using the join query as a view.
Thanks
Mark

you wont be able to do this in the data Assist wizard, you will need to modify the recordsets after the pages are created.

Ah Haa, Penny drops, Many thanks.