Jump to content
The site is updated on a beta version. Maintenance tasks are running so search and index may not function at this time. ×

A newbie - look up items and add to order


Recommended Posts

  • Newbies

Hi All.

I've come back to FM18 after last doing anything with it back in 2011when it was FM11 but I can't remember much about it.

We have been offering a Thai food delivery service for a few weeks and it's getting bigger and busier.

I have 42 Thai menu items that I want to auto populate in text boxes to create an order. I have created a value list with the 42 items and I just want to type in a menu number, eg. 23 and it will add Red curry prawns item to a bill. The price is a box alongside the menu item. It also needs to call up the price of the item and complete a box alongside the menu item. I have created 15 items  in the form of a customer order which should be enough and I have the amounts totalling but they are not connected to the menu items and I have no idea how to do that.

Our clients are also on a list of around 160 people/addresses and I’d love to be able to do the same with them by entering just a name or address so it’s a speedy process. Are value lists the answer please?

I know Google is my friend and all that. It's knowing what to ask Google!

Thanks.

Link to post
Share on other sites
  • Replies 6
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Posts

You are describing a standard structure of: Customers --< Orders --< Order Items >-- Products Each of these entities should be a table. In this arrangement, an order can have any nu

No value lists are not the answer -

A portal or a list view of your menu items is easier to select from to add to an order.

Or a field you type in to and it adds it to your order it will lookup the prices from your prices table. 

the Order will have order items each item can lookup the menu item and its price from a separate prices table.

 

Here is an example.

Link to post
Share on other sites
  • Ocean West changed the title to A newbie - look up items and add to order

You are describing a standard structure of:

Customers --< Orders --< Order Items >-- Products

Each of these entities should be a table. In this arrangement, an order can have any number of items. Once you select a product for an order item, the price should be looked up from the related record in the Products table. This allows you to change your prices without affecting past orders. Other details can be also looked up or displayed directly from the related record - depending on whether they need to be recorded as they were at the time of the order. The same thing applies to selecting a customer for an order.

 

  • Like 1
Link to post
Share on other sites

Exactly - you can even extend things further such as attributes to each item - 

No Item Heat Price
23  Red curry prawns  Medium 12.42

(great now i want curry for lunch - @rasg do you deliver to san diego? )

check out the sample starter solution File -> Create New -> Invoices that has an idea to get you started. 

Link to post
Share on other sites
  • Newbies

Sadly, San Diego is a little too far for us! Thanks for the information.

Presumably, if I wanted to take this further, it's possible to pull the customer info from the contacts list on my Mac?

Link to post
Share on other sites
  • Newbies

Is there anybody around here who would be willing to put a skeleton of the database I need so I can add the data etc?

Essentially 42 menu items. 42 prices. levels of spice. Price.

Name, first line of address and postcode.

When a customer calls or emails no typing needed. On an order page. Call up customer with name or postcode. Up to 15 items on an order with item name, price, spiciness and total. NO typing should be needed. TIA.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.