2 table dynamic fileds

[owaring]

I may be having a bit of a senior moment here but wanted to put a question out to the room.......

I need to create a price list. SImple enough eh?!

This list should have 2 'sets' of management.

Firstly should be a list of aircraft, priced per hour

second is a list of types of lessons in those aircraft

each aircraft has a different price for a different lesson etc

the management should be able to add aircraft and lesson types as they see fit.

how would you approach this?

[Matthew F]

I'm not sure that you need to create relationships to handle this. Why not just create a popup list for Aircraft names that uses a value list based on the existing names, and create a similar popup list for services?

[owaring]

each aircraft has a different price for each different lesson

eg

Aircraft 1 - Lesson Type 1 - £1

Aircraft 1 - Lesson Type 2 - £2

Aircraft 1 - Lesson Type 3 - £3

Aircraft 2 - Lesson Type 1 - £2

Aircraft 2 - Lesson Type 2 - £5

Aircraft 2 - Lesson Type 3 - £2

Aircraft 3 - Lesson Type 1 - £5

Aircraft 3 - Lesson Type 2 - £21

Aircraft 3 - Lesson Type 3 - £4

Each time a new lesson type is added a field needs to become available for each aircraft..........

[comment]

Each time a new lesson type is added a field needs to become available for each aircraft..........

That's not going to happen. The correct approach is to have three tables: Aircarft, LessonTypes and Prices - where each record in Prices is related to an aircraft and a lesson type, and contains ONE price.