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?

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?

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..........

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.