Repeating Data

[icemac]

Here we go again i have another problem.

I am finding it very hard to explain my problem so i have attached a copy of my database:

Have a look at NUMBERPLATE OPTIONS in the booking table. When you click on this field you have to type in the END DATE and the CAR TYPE to generate a list of numberplates that can be selected. This END DATE and this CAR TYPE have already been enetered into the BOOKING TABLE for this particular record. Is there anyway of repeating this data entery?

Iain

 

[Brianwarnock]

Took a quick look but as i have to go out I won't be able to do more than make a couple of observations.
1 You have no forms and yet you refer to a form in the query of the rowsource of number plate
2 You are obviously entering data directly into the tables, I only ever do that on very small test databases. I believe that one should always input the data via a form, I'm sure that that would make running the queries on entry much simpler.

Brian

 

[icemac]

I had to delete the forms to make the database to make it small enough to post. Is there anyway of not having to enter the data twice or do i just ahve to enter them in the search boxes?

 

[Brianwarnock]

Hi got a chance to look at this yesterday.
Tip 1 Compact a database before zipping
Tip 2 Do not have blanks in object names it makes syntax problems more likely

I didn't like your use of Like and without your forms could only guess as to why you were using them. I initially re-did a search Form with separate parameter boxes which solved some problems but I could not get the whole thing to work so started from scratch, using your tables but with afrmBooking_table form. All input is via this, I also scrapped one of the number plate fields and changed it to carmake, Car Model in your terms.

I did nothing about the customer, but hope what I have done helps you towards your goal.

Brian

 

[Brianwarnock]

Well Icemac you were quick to PM me when you had a problem, but a comment as to whether my work on the DB was of any value would have been appreciated even if it was in the negative.

Brian