I have a form with subform (form =riders and sub form=the races they are entered in). Whilst some data is constant, other data changes for each record. For example, a rider may have a default motor bike (details recorded in the riders table) but for one race, he may use a different bike (eg sidecar event). Is there a way I can
1 automatically copy the default info (eg bike details) from the main form to the sub form
2 but still allow that “suggested” data to be overtyped with the info for this particular event
Mascochist bit . I am trying to rewrite a database that is used to record details of motor bike meetings. It needs to record who was entered for each of a series of races for different meetings, calculate the costs of that riders participation for that meeting, record receipts for payments made and a whole raft of reports including list of riders for events, numbers to be pasted on their bikes, summaries for banking etc. Basically I have the process working but am fine tuning and not only can I see some inefficiencies in the original design (eg manually calculated “sort Key” as the major link though the whole database, but I’m sure I am doing some dumb things too. Would this database be complicated enough to be used as a training exercise here but simple enough so as to not drag on forever. ie I would start from scratch and ask dumb questions about everything starting from design of the database right though to the finished product and implement suggestions with feed back as I went or is this a really dumb idea. If it is really dumb, I would appreciate any help on the form sub form idea
TIA
Steve