Advice on Layout and Table Relationships

[mixnplay]

Hello all,

 

I am working on putting together a system to track event sales.  So here is what I have so far and what I am wondering is the best thing to do. 

 

I have made three tables.  Venues, show dates, and daily sales. 

 

Venue is a list of Venues with details

 

Show dates if the list of events

 

daily sales is where the daily sales for each event will be updated and stored. 

 

 

 

What I am trying to figure out is the best way to updated the sales numbers.  

What I want to do is have a page with all the upcoming events listed and be able to enter the new sales record for each show.  

 

Can this be done in a portal?

 

any and all help is appreciated. 

Ry

 

[MicheleC]

I assume you have related your Sales table to your Show Dates table.   Is there just one item in the Sales table for each Show Date?  If so, let's say that field is called Total, then on your Show Dates layout, if you insert the field Sales::Total you can enter sales information right there on the Show Dates layout.  Is that what you want to do? 

 

However, if that IS what you want to do, why bother keeping Sales in a separate table?