Member Avatar for riaanplaas

Hi all , I am a farmer, macadamia nut farmer.
I created all the tables i need too, and set all the relationships. Now:
I have diffrents blocks on the farm, each has a name, so i created a table with the names of the blocks as the field headings, and each block has different anmount of trees that i entered onto the table under the diffrent block headings. Gr8t
I also created a table for my spraying schedule. So i used the wizard to create a form from tha table of spraying schedule. Gr8t
in the spraying schedule form , i have a dropdown list(combo) for each block that needs to be sprayed.
I also have a control (textbox) that i want to display the values of the amount of trees in each corresponding block that is selected in the dropdown list on the form. How do i go about that?

Thanks .. Nut regards

  • 2 Contributors
  • 1 Reply
  • 50 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by MidiMagic
Member Avatar for MidiMagic

This is a place where you should use a query. With it, you can display data from different tables in the same screen.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.