AnsweredAssumed Answered

Orders database design?

Question asked by JamesWatt on Dec 24, 2013
Latest reply on Dec 28, 2013 by philmodjunk

Title

Orders database design?

Post

     I'm using FileMaker Pro v13.0v1 (Mac).

     I'd like to create an orders database.  The database should contain customer information, order date, etc.,etc., but also a variable number of "lines" for what's being ordered.  By "lines" I mean that's what it would look like if it were printed.

     The customer info, pickup info, etc. is easy enough but it's the order items part I can't figure out.  I'm not even sure what to call what I want.  Portals are limited to a fixed number of visible fields so that's not good.

                
               Preferences
§
1
2
3
4
5
6
7
8
9
0
-
=
Backspace
                     
Tab
q
w
e
r
t
y
u
i
o
p
[
]
                          
Return
                          
                     
capslock
a
s
d
f
g
h
j
k
l
;
'
\
                     
shift
`
z
x
c
v
b
n
m
,
.
/
shift
                     
                          
                         English
                               
                               
alt
alt
                     
                
               Preferences

     Any thoughts on how to do this or an example orders database?

     Thanks for any help..

     James.

Outcomes